IF(
Discussion List
- Hi! I have a date column and i would like a forumla in another column to complete that cell with the word "completed" when the date is added. Im creating an exterior report that i want to show just th…
- If Date of Calibration is blank, return N/A instead of DUE. =IF([Calibration Due]@row - TODAY() > 90, "GOOD", IF([Calibration Due]@row - TODAY() > 30, "3 MONTHS", IF([Calibration Due]@row - TODAY() > …
- I need this formula in the June 2024 column and below is what I need it to do. It should be one big long formula and I'm assuming it would be a IF statement. I could set up automations for this but th…
- I am not sure how to "Nest" if functions for my application or if I need to use the "AND / OR" functions with it. Essentially, when my field team updates the [Field Status] column I want the appropria…
- I am trying to get a value when I put in a particular date If a person puts a date in the Target completion field, I want to return a Sprint in the Sprint field. I dont know if I can use the month or …
- =IF(Total score]@row > 2, [Executive Sponsor Approval]1 = "No"), "Yes", "Submit"), Executive Sponsor Approval)) Hello, I am new to formula writing. Can someone help me write a formula where If total s…
- Hi! I am a SS newbie and can't figure out what is probably a very simple formula. I am needing my Project Status to change to "Design" when the ALTA Survey Completion is checked actual and/or when the…
- Example: When I change the Status column dropdown option to "Complete" how do I write a formula to automatically change the percent complete? I.E. Status is "Not Started" = Percent Complete is "0%" St…
- I want to use a formula to isolate the training type into a single column. Currently, "Training Type" is a primary column so I am unable to make it a dropdown selection and automation would take too l…
- I can get both of these to work separately, but when I try combining them, using IF(OR or IF(AND or even just another IF(, the "Yellow" part won't work. Suggestions, please? =IF([Milestone Due Date]@r…
