-
'Request an update' Automation: 'Condition' where column contains a cross-sheet reference.
Will the automation “Request an update” fail if the 'Condition' column contains a cross-sheet formula that pulls data from another sheet? For example, there are two Smartsheets: Sheet ONE contains Project ID, MFG Rep and Customer Price. This is the source sheet for Project ID and MFG Rep. Sheet TWO contains Project ID, MFG…
-
Is there a way to use a CountIF formula that would ignore hidden rows/cells?
Hello, I am am trying to create a summary report that would count the number of "complete", "not started", and "In Progress" with only using the rows/cells that are filtered. I do not need to count the rows/cells that are hidden but when I use the COUNTIF function, it would also count the hidden rows/cells. Thank you.
-
Sheet Summary Formula Needed: Sum all numbers in a column for rows which match a criteria
Hi, I am looking for help writing a sheet summary formula that will sum all numbers in Column B for all rows matching a criteria in Column A. I have a sheet that tracks transactions by salesperson. Each row is a transaction. I have column that contains the commission for the salesperson for each transaction. In the sheet…
-
Is there a way to trigger a workflow if an end date changes by 5 or more days?
I'm looking to create an automated workflow to copy any row from a project plan that has the end date changed by 5 or more days. Is there a formula I can include in the automated workflow to accomplish this?
-
Vlookup range not updating with form submissions
I have a sheet with a list of employees that references form responses on a different sheet, and via vlookup function pulls in the date a form was submitted (to track who has submitted the form, and who as not yet done so). The problem I'm having is the vlookup range automatically limits itself to the forms already…
-
Elapsed time accounting for weekends
I see many threads referring to elapsed time calculations (i.e. the time between a start date/time and end date/time) and many promises from Smartsheet to add this function natively at some point, yet I still don't see a solution. This is a complete showstopper for our application of Smartsheet. We need a way to calculate…
-
Cells not adding together
I have a sheet that has one column that I am needing to total . The formula consist of only 3 cells in the column but it is only adding one cell in the total. Any suggestions?
-
How to Automatically Flag the Flag Symbol Column
I'm looking for an IF/COUNTIF formula for automatically flagging the flag symbol column when a contact's name appears in a Contact column for a 3rd time? (incident tracking report)
-
Help with RYG Balls - Looking for an Average
Good morning/afternoon. I have been searching in the help articles and community for an answer to my question, to no avail. I have tried a few different suggestions but nothing has worked so far. Here is my dilemma. I have a sheet that has linked in RYG balls for health from another sheet. There are three sections, with…
-
Red Flag for overdue tasks
Hi, I have used the formula =IF(AND([% Complete]@row < 1, [End Date]@row < TODAY()), 1) in the flag column to turn the flag red when the end date is passed and completion is less than 100% which is great. BUT.... It now red flags every row that doesn't have a date in yes which is an issue as we are using a project…