-
Auto Prompt
I am trying to create a smartsheet for Attendance for my office. I want to give the option in the smartsheet where my Supervisor can select the nature of offence - it gives them the recommendation of what is the action needs to be taken rather going to the procedures to read everything and find out. Is it possible to…
-
Can I use a COUNTIFS formula based on the date a cell was populated?
Can I use a COUNTIFS formula based on the date I added a value to a cell? The information within the cell will not be a date. I have a Smartsheet with a list of project ideas. Once it's added to our project management tool, it gets a number (ex: 123456). I have a column for "Project Number". I would like to add a line to…
-
Pulling past data
Hello, I'm interested in pulling past data of when a trigger happened in a particular cell. We use smartsheets for project management for our creative projects, and I'm curious how long it took from when the project was supposed to be done vs when it was completed. We have a check box on a cell that a person clicks when…
-
VLOOKUP vs INDEX MATCH
Confused! I have a sheet that has a checkbox column (Start). I want another sheet to reference that sheet, look at the Task ID Column and see if Start is checked on that line, if so, check the Start box on the "other" sheet. The formula below is on the "other" sheet in the Start checkbox column. =IF(VLOOKUP([Task ID]@row,…
-
Counting single values with multiple criteria
I need a little help with a formula in Smartsheet, I am trying to count the number of employees who are over utilised (> 105) but some employees have multiple entries (same utilisation, so only need 1 entry in the count). Answer below should be 3
-
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…