Trending in Formulas and Functions
-
% in formula issue
Good morning, I have a column which named "% Complete". The next column, I wrote: =IF([% Complete]@row = 100, "Complete", "Not Complete") That works if the % complete column is 100. But it doesn't work if I turn the "% Complete" column into a percentage format. How do I tweak my formula to state that if it's "100%", it's…
-
Average of values if criteria is met in two other columns
Hello, I am trying to determine the average of values in one column (Days Open) if criteria in two other columns is met: (Date Closed) is from last month (Facility Name) is a specific dropdown option from this column I can calculate average based upon date closed being from last month, but adding in the second criteria…
-
Trying to create an on-call schedule with auto-calc'd dates
I am setting up an on-call schedule for all of the teams in the department. I want the start dates to auto-calc based on the prior row for the same team. I used AI to create a formula and it works. But when I went to make it a column formula, SS says that the format is not correct! This is the sheet. This is the formula in…