-
At Risk Flag Automation
Hi There! Need assistance with a formula. What I have so far is: =IF(OR([Agreed Upon Complete Date]@row < TODAY()), IF(AND([Agreed Upon Complete Date]@row <> ""), IF(AND(Status@row <> "Complete"), 1, 0))) This is working great for if the "Agreed Upon Complete Date" is in the past and the status is not complete, turn the…
-
How to create IF formula with multiple conditions
Hi everyone, Newer Smartsheet user here! 😊 I am setting up sheets to capture ongoing project status updates from team members. I have a (dropdown)column that shows QI Phase and a blank column that shows % complete. Ask: I am trying to figure out how to write a formula that will reflect a % complete based on what phase a…
-
Create Order of Response If Text is in Cell
I have a multiple select as part of a form. I want to create a column that looks for a specific text within the multiple select and create an order of response. So if multiple forms are submitted with the item A selected in them, I would like the first submitted be an order of 1 while the 2nd time item A is selected then…
-
Creating a formula to count each selection in a cell drop down.
Hello Everyone! I am looking to edit a formula I am working on to count every option available in a cell. This is the formula I have currently. =COUNTIFS({2024 Documentation & Projects Range 4}, FIND("CC:", @cell) > 0, {2024 Documentation & Projects Range 5}, FIND("ILT", @cell) > 0) As you can see, it is only looking for…
-
Counting a Column with filled data
Hello Everyone! I am looking to edit a formula I am working on to count every cell in a column that has data filled from a drop down. This is the formula I have currently. It is looking for data in the first column that contains "CC:" but I am trying to figure out the second half that counts the amount of cells in another…
-
Subtracting from another cell when data changes
Hello All! I am trying to have a cell that is reflecting the total of projects I am working on to subtract from another cell whenever that cell is change, reflecting that the project is complete. In the screenshot below I want the Total Cell to Subtract the Completed cell. The formula grabbing other data from this sheet…
-
Gantt Chart Consolidated Milestones
Has anyone found a way to consolidate multiple milestones in a gantt chart so that they appear on one line? At the moment, each critical step can only be shown on a separate line, but after 1000 projects, the Gantt is overwhelming. Id like to have one line with all the key steps consolidated...Not sure if this is possible…
-
Autonumbering limitation
I have a column in my sheet named "case number" which is an AutoNumber. For my use case, I will occasionally need to escalate a case to another department and I need to create a reference number compatible with their system, lets call it a "XYZ number". I would like to check a box and have this number generated, i.e.…
-
Generating Documents (Certificates) and automatically Emailing as Attachments
I use smartsheets for people to take knowledge checks. When they complete the check, I have it mapped so that a PDF completion certificate is generated with their name and date of completion on it. When I set up the workflow to alert that this document was generated, it takes them out to the actual smartsheet. What I want…
-
Filtering on dashboards?
I'm new to smartsheet and trialing it at the moment. I have a question, I hope you can help me with: I have a portfolio of companies in a main sheet and their debt issues, and related stuff in several sheets. Rows are companies/debt issues, columns are details of these. I want to collate all this into the dashboard used…