-
Formula to Automatically Return Column Pending
I have a Smartsheet that is being used to login dates as an item is processed through various steps until completion. I would like to create a column that automatically shows what step in the process the item is on. I can do this by combining if/then formulas, but there are at least 15 steps and I am hoping there might be…
-
How can I add days to dates based on text in another column?
I need to have a specific number of days added to a date that is in Column A, and have it add days to Column C, based on the text that is in Column B. Example: Column A is SC (needs +20) Column B is 7/29/2020 Column C should = 8/18/2020 I have found that (A1,"SC",B1)+20 works per text, but I have 12 different variances of…
-
Auto Populate Today's Date
When a condition in "Column A" changes to "YES", I want the date in "Column B" to automatically enter today's date. How can I do that. If I use the TODAY function, that cell will update to today's date every day - and I only want the date "Column A" changed to "YES".
-
Help w/COUNTIFS and multiple NOT(CONTAINS) functions
Hi team - I created a formula to count the number of numbers of errors in a specific month and does NOT CONTAIN "general counsel" in the Division Requested By column, the June example works: June example formula: =COUNTIFS([Main row]:[Main row], 1, Created:Created, IFERROR(MONTH(@cell), 0) = 6, [Incorrect…
-
Next Payment Due
Using MIN COLLECT to select from dates the next payment due date. Nothing is being returned. I can't figure out what I am doing wrong. Next step would be to select the value associate with the date. =MIN(COLLECT([Year 1 Due]1, [Year 2 Due]1, [Year 3 Due]1, [Year 4 Due]1, [Year 5 Due]1, [Year 6 Due]1, <TODAY()))
-
How do I use IF formula to change a colour based on a percentage column?
I have a status column with red, yellow and green. I'm needing a formula to change these colours when the percentage complete column gets below a certain percentage. i.e. 1-50% Red 51%-99% Yellow 100% Green
-
How to conditional format a cell where no further action is required.
Hi, I am trying to build a heat map of different teams required for various projects to workout a heat map. The first column is name of the deliverable and the next 10 columns are completed by PMs. These 10 columns are various technical teams and PMs choose from the drop down to indicate which months they need. The colour…
-
How would I update a row status based on what has been checkmarked in the same row/multiple columns?
Hi everyone! Need some help with this one, I've been stuck on it for days! Essentially what I'd like to happen is we are having a process that must happen in chronological order (starting at Page Created to the right). What we'd like to accomplish is the Overall Status to update based on what has been completed (check…
-
IF(AND formula to be used with Star Symbol
Hello, I have an On Time column that when conditions are met populates a colored star. If the store opens after 6 am the star does not color. If the store opens between the hours of midnight and 6 am the star is colored. I keep getting #UNPARSABLE error (the [Value_if_false] highlighted in yellow when i go into the…
-
IF formula giving me #INCORRECT ARGUMENT
I am using this formula to set status' in my sheet. =IF(ISBLANK(Cost4), "Request Submitted", "Request Reviewed/Priced", IF(CONTAINS("Approve", [CEO Approval]4), "CEO Approved")) I am getting an #INCORRECT ARGUMENT error. What am I doing wrong?