-
How to display Days Elapsed only if Status is Open?
Like the title says, I'd like to only show the number of days elapsed when the status is on Open. I'm currently using this formula: =IFERROR(NETWORKDAYS([Report Date]@row, [Due Date]@row), "") Any tips would be highly appreciated!
-
CRM Templates and Formula for tracking company change
Hello all, Two part question: What success have you had using the Smartsheet CRM templates? We have decent adoption with Smartsheet, and no adoption with salesforce, so are looking to do our CRM in Smartsheet and leverage the data we already have (client info, contracts, etc) Second, I am looking for a way (formula,…
-
Table has dates in 7 different columns and I need to compare them all
Background: this is a marketing "push date" table that alerts staff when stuff needs to go out. Each row is an individual event. There is an Event Date column, and the other 7 Date columns key off of that. Any row will never have the same date in any of those 7 columns. There are quite a few rows, one for each event…
-
Unique IDs that combine a field and sequentially increase
I'm creating a change management log that allows users to submit change orders via a form. To simplify this question, I would like the user to include the project number in their request (this will populate a sheet column titled "Project Number"), then a formula in the sheet (in another column titled "Change ID") will…
-
Conditional Formatting Based on 2 Date Columns, with or without Helper Column
Hi! I've scoured the Community posts, and can't find exactly what I need. I am managing a membership list and need to flag when memberships expire before or on a specific date (06/29/2023) so I can contact those members. I have one column with their membership expiration dates, a second column with the 06/29/2023 deadline,…
-
Change Parent row status based on status of child row
Hi Team, Is it possible to that the Parent Status can default or change to Delayed only when any 1 of the Child Task row has Delayed status. Is that feasible through Automation WD or formuale.
-
USing IF and ISBLANK with two columns
Please help. I posted this almost two months ago and still have gotten no help. I am currently using AT-RISK indicators for certain tasks that have not been closed. The first formula works but does not turn off on the indicator once the task is closed. =IF([Committed Closure Date]@row - TODAY() > 10, "Green",…
-
SUMIFS the two columns meet the criteria for each column (USA)
Hi, I am working on this formula,... What am I doing wrong? criteria 1 is the words --"2022 Donations" and criteria 2 is data between two dates for quarterly sum of $. =SUMIFS([Paid $]:[Paid $], Codes:Codes, "2022 Donations", Date:Date, ">=01/01/2022, <=03/31/2022")
-
Formula to Total rows
I have Rows with names of People Then I have columns that show projects / Activity names I am trying to create a summary field that will sum all the time spent on two categories by all the people. Either "Customer Meeting" or "Testing". The rows those are listed in might not always be the same. For example one month they…
-
Invalid Data Error
Good morning everyone. I have a formula to count the number of days between two dates column. In one column, similar formula is working but in the other column (with different reference data) it does not. Can someone take a look and advise what I am missing. I searched in the community to see if there's a similar topic…