-
Special IF Formula for Stars
I have two columns: * [Infrastructure Project] is a checkbox * [Product Priority] is stars (0 - 5) If [Infrastructure Project]@row is checked, I would like [Product Priority]@row to be 5 stars. If it's not checked, I would like manual entry for the stars. This would be simple if [Product Priority] were empty, but I already…
-
Huge Sports Event in planning
Hey guys. I am just starting to setup a sheet for a huge sports event that shall provide all relevant info, but also be used live to update the onsite status. Basically there will be about 10 stations that will be identically except for individual timings and some details (i.e. number of people per team). My client does…
-
Status - Red, Yellow, Blue
I haven't done formulas in a while but can someone help me out with the following. I attached a screen shot below. If %Complete is 100% then status would be blue If end date is less than 10 days away then status would be yellow If end date is on or past end date then status would be red. Thanks
-
Referring to Adjacent Row
I am using the following formula in Color column to shade every other row in a sheet: ROW 1: No formula ROW 2 = IF(Color1 = 0, 1, 0) ROW 3 = IF(Color2 = 0, 1, 0) I have over 1,000 rows. This works fine. However, if I insert a new row, I have to drag the formula from the row above all the way down to the last row the fix…
-
Formula to Create Unique ID on Specific Rows
Hi Everyone, I am trying to create a unique ID but only on specific rows, so the auto-number column type is not suitable. I would like the ID to be sequential. I started by generating a number, 1, where Course and Action Due Date are blank. I have successfully done this by using the formula: =IF(AND(ISBLANK(Course491),…
-
COUNTIFS to include cells with text
I need to create a cross-sheet formula that counts the number of entries for a month and if there is text in another column. I've come up with the formula below, but I get an Incorrect Argument error: =COUNTIFS({Review Month}, =1, ISTEXT({Critical 1})) Where am I wrong here?
-
From X to End of column
My sheets have a "header" that serves as a navigation and also serves for the metrics. My problem is that I would like to have the range of a function encompass the entire column (open-end) but i want to be excluding the aforementioned header rows. I tried thing such as [Column Name]21:[Column Name] in an attempt to splice…
-
Highlight If Older Than 'X' Days
I'd like to use conditional formatting to highlight a row or cell if it's older than 30 days. It's helpful for us to see which tasks are stale. However, there's only an option for "In the last 'x' days" or "older than (a date)". Has anyone found a good workaround or submitted this as a feature request?
-
PLEASE tell me what is wrong with this formula
=IF(Status8 = "Complete", "Blue", IF([Due Date]8 < Today8, "Red", IF([Due Date]8 = Today8, "Yellow", IF([Due Date]8 > Today8, "Green")))) Very new at this, but I can't see the problem...
-
Complex Formula for RYG Automation
I automated the RYG circles according to several columns of a Smartsheet grid for project management purposes. The logic is below: IF [Proposed Product Launch Date] <TODAY, "Gray" IF [Proposed Product Launch Date] >=TODAY AND [Deviation from Proposed Launch Date] <100, "Green" IF [Proposed Product Launch Date]…
