Sign in to join the conversation:
I am trying to created check point progress with check boxes and a visual aid. I created a If formula, but my progress is not adding up. I would like to know if anyone can help me with a better formula.
=IF([Classes Complete l]2 = 1, "Quarter", IF([Classes Complete ll]2 = 1, "Three Quarter", IF([Classes Complete lll]2 = 1, "Full")))
This is the formula. I am using, but its not working.
Hi,
Try something like this.
Starting with the last one first because the formula will stop when something is true.
=IF([Classes Complete III]@row = 1; "Full"; IF([Classes Complete II]@row = 1; "Three Quarter"; IF([Classes Complete I]@row = 1; "Quarter")))
The same version but with the below changes for your and others convenience.
=IF([Classes Complete III]@row = 1, "Full", IF([Classes Complete II]@row = 1, "Three Quarter", IF([Classes Complete I]@row = 1, "Quarter")))
Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.
Did it work?
Hope that helps!
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
Hello! I have this formula that will check the box if the date in a second column is in the past. Is there a way to include if the date is 60 days in the future? Check the box if the date in Column 2 is either (1) in the past or (2) 60 days in the future. IF([GWO - BST (2yr)]@row < TODAY(), 1, 0) Thank you in advance!
Is there a way to automatically update my dropdown list for a form if I have a new item added? I have a New Order Entry form. I have a dropdown list of customers, but if it is a new customer, there is a checkbox to allow more fields to open up to enter that information. If that information is added, it gets copied to a…
Hi! I'm trying to figure out how to use the NETDAYS formula to show how long someone has been a member of a certain team. I can't get it to measure to today using the formula that the website suggests. I want it to be running so that whenever I log on I can see the time elapsed to the day I'm looking at the sheet. Can…
