-
Need a formula to fill in a column based on a date column
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 the info for the completed rows but the only way we know its completed is by this date being added. If the date column is…
-
If Cell Blank Return "N/A"
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() > 0, "1 MONTH", "DUE")))
-
Formula Question-I need to create a IF formula based on other cells criteria
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 that's a lot more work than just figuring out a formula since I am going to use this formula for many months to come on this…
-
IF Function With Multiple Drop Down Selections
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 appropriate colored circle to update in the [Risk Status] column. Red = Delayed Gray = Not Started Yellow = In Progress Green =…
-
IF function to return value based on dates
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 does it have to be between? For example =IF([Target Completion Date]@row) is between 8/1/2024 and 8/31/2024 then return…
-
If more than value,Submit, if less No
=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 score >=3, then change Executive Sponsor to Submit and if not, then change Executive Sponsor to No. I will have an approval…
-
IF statement for when boxes are checked
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 As Built Received Actual is Checked.
-
What is a formula to capture % Complete when the "Status" changes?
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%" Status is "In Progress = Percent Complete is "50%" Status is Complete = Percent Complete is "100%"
-
What formula would I use to pull text into a new column?
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 long to do (there are over 100 rows). So I want to use a formula to isolate the training type from the "Business Segment, RCM…
-
Need help combining these 2 IF statements
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]@row > ([Today Helper]@row + 30), "Green", IF([Milestone Due Date]@row > ([Today Helper]@row + 7), "Yellow", "Red"))…
