-
COUNTIFS Referencing another sheet and pulling data from a specific time period
Hello, I am trying to create a formula that will pull the number of times an entry was submitted for a specific location from another sheet, but I want to set the date it should start counting from and no end date. The data that the formula will compute I will then use as a reference cell for a chart I created on a…
-
Help w/ COUNTIFS and ISBLANK and NOT ISBLANK
Hi team - I have 2 columns (Seat and Open Req) that I need to count: When Seat = Filled and Open Req is not blank When Seat = Filled and Open Req is blank I'm struggling with the COUNTIFS sequence to get this to work. Any help would be greatly appreciated.
-
Project stage and date in the Future
Hello Smartsheet super formula humans! I need some assistance! We are trying to create a formula where a checkbox is checked if the project meets the below criteria. Recurring On hold Pending approval + In Progress with a Go-Live date of after 3/31/21 The Recurring is its own checkbox without a formula, the On Hold,…
-
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…
