Interested in scaling your back end operations without doing it all alone? Schedule a call using www.optimizeis.com/main

Thank you for your valuable info )

@BenGreenSystems

Жыл бұрын

Glad it was helpful!

Question: I want a conditional formula based on status that produces a due date that is based on a set event date. Ie. When an event date is set, a "complete no later than" date is populated that is based on the status of planning. Does this make sense? I've successfully gotten this far: IF(Phase="Initial", DATEADD({Event LIVE Date},-45,'days'), "") But I can't format as a Date (no time ... the result looks like this: 2023-05-10T00:00:00.000Z), and I can't seem to nest the other statuses of planning.

Ben thanks for the informative videos. You explain things very well. I'm just getting familiar with Airtable, but have high hopes that the combination of Airtable and Glide will enable our team to create some cool apps for our field HVAC team.

@BenGreenSystems

Жыл бұрын

Glad it was helpful! I would be happy to give you a few hours free to learn how an HVAC business is using Airtable. Airtable and Glide is a great combo, as long as the team uses it. Find a time here and we can talk www.optimizeis.com/schedule-page

I'm using this formula DATETIME_FORMAT({Date Sold/Ended},'W') however it returns #ERROR when the Date Sold/Ended field is not filled in. I tried creating this formula If ({Date Sold/Ended}=0,BLANK(),DATETIME_FORMAT({Date Sold/Ended},'W')) but Airtable automatically removes ,'W' portion so it only returns the date and it is returning a blank. I need the weeks to show. Any thoughts?

@BenGreenSystems

3 жыл бұрын

maybe instead of {Date Sold/Ended}=0, use {Date Sold/Ended}=""

Can I use nested if with the NOT function? I want to say: if a, b and c fields are not empty then y, if a, b, c, and d fields are not empty then z. Some of the fields I'm referring to are attachments, some are text and some are checkboxes 😬

@BenGreenSystems

3 жыл бұрын

You should be able to use an ! for not empty. EX. If({Field}!,{value if true},{value if false}). If this does not work, let me know and I may have some other ideas!

@TallyKerr

3 жыл бұрын

@@BenGreenSystems no it doesn't like the ! it just comes up with an error

@TallyKerr

3 жыл бұрын

​@@BenGreenSystems I've got the formula working if I make them all tick boxes if that helps (please also let me know if there's a more elegant way to structure this 😅) IF( AND({Members registered online}=1, {Webpage completed}=1, {Welcome fair/meeting}=1, {Attended 1 GM}=1, {1 Committee Member Trained}=1,{Constitution Uploaded} =1, {Attend 2nd GM} =1, {2nd Committee Member Trained}= 1, {Treasurer Received Finance Training}= 1, {2 Events on Website}=1, {1 Community/Sustainability Event}=1, {Handover Document}=1, {1 Committee Member Received Awareness Training}=1), "Gold", IF( AND({Members registered online}=1, {Webpage completed}=1, {Welcome fair/meeting}=1, {Attended 1 GM}=1, {1 Committee Member Trained}=1,{Constitution Uploaded}=1, {Attend 2nd GM}=1, {2nd Committee Member Trained}= 1, {Treasurer Received Finance Training}= 1, {2 Events on Website}=1), "Silver", IF( AND({Members registered online}=1, {Webpage completed}=1, {Welcome fair/meeting}=1, {Attended 1 GM}=1, {1 Committee Member Trained}=1, {Constitution Uploaded}=1), "Bronze"))) It's for an accreditation system, groups have to fulfil certain criteria to be accredited bronze, silver or gold. However I'd like the fields to be able to capture the evidence too so some will have a screenshot attached, some will be a text field, some will be just a check box.

@TallyKerr

3 жыл бұрын

@@BenGreenSystems I fixed it! I just had to duplicate every column so there was 1 column that contains the evidence and then one that is a formula that is ticked if the evidence folder is not blank. Then the original formula to show whether they are bronze, silver or gold works off those ticked columns - not the most streamlined but it works!

I find it confusing when you used “Done” twice in the nested IF formula.