-
WorkApps roles in control center
I need a suggestion or a workaround. I have more than 20 contacts for Recon Approver for multiple selection per cell, and the Smartsheet limit is 20. I want to add all the contacts so that when I create a new project in Control Center, all the contacts will be able to see the project(s). Is there another way to accomplish…
-
Resturant management
Is anyone using Smartsheet to run a restaurant financial management? And other related topics I am thinking to utilize smartsheet for cost management, revenue, inventory, assets management. Any thoughts where to start? I have a background in using Smartsheet to develop templates and use reports to form numerical…
-
Dropdown list restrictions
Is there a way to limit a dropdown list so that the values in the dropdown list can only be used once in a column?
-
Conditional Formatting Query
All the above rules are working except the 4th one in the list which asks for the cell to turn red if Group status is not started and end date is in next 14 days. I have used the Smartsheet AI tool but no luck, I have saved and refreshed. I am using a helper column for my 5th rule in the list which asks the cell to turn…
-
Set Task Duration from Formula
I have a project with many repeated subtasks, and sub-sub tasks. To generalize: Task A has Subtasks 1, 2, 3 Each subtask 1, 2, 3 has sub-sub-tasks a, b, c I would like to describe the duration for Subtask 1 with a, b, c in a general set at the bottom of the sheet. Can I link the duration of Subtask 1, 2, and 3 to the…
-
Planned vs actual progress (Summary level)
Hi everyone, I am trying to calculate the % Planed based on the start and finished dates but when I try to set the Complete (actual) progress just to verify that all of my plan y on date, I see that the summary tasks are not calculated correctly. I am using the following formula =ROUND(IF(TODAY() < [Baseline Start]@row ,…
-
Automation not triggering all of the time
Hi Smartsheet community, I've always tried to answer questions but this is my first time posting. So I have formula =IF([Project Status]@row = "Complete", 1, 0) set up in the "Complete Check - Hide column" to check the box when the project status is marked complete. The project status column is tied to several other sheets…
-
Getting error message in approval email
Hey, Is anyone else facing this issue in the approval notifications sent through smartsheet
-
Verification of completion of all actions on a sheet
I have a checkbox for 3 separate columns for 3 individuals to check to indicate they have verified an action. The goal is to count the 3 checkboxes if checked and to have one checkbox only for leadership to verify all actions are completed on the entire sheet without having to check every individual task.
-
Find information within a formula
Hello, I am trying to find information within formulas that reference a given cell using CTRL + F. The data is in the cell [2028 (CY)]214. I have tried the following: [2028 (CY)]214, *[2028 (CY)]214, = [2028 (CY)]214, = * [2028 (CY)]214. However, it returns 'no matches found'. Does anyone have advice or is this not…