functionality
Discussion List
-
One off Saturdays in GanttIn Using SmartsheetHi all, I work in construction and use the gantt chart heavily to manage scheduling subs. I have a unique situation for my project where I may have to schedule work on a Saturday. Is there any way to allow a single Saturday, instead of o…
-
Referencing Multiple Columns in another sheet to Match a Location and Date Range to a ProjectIn Formulas and FunctionsSo I have been looking through the community for a while and have seen a couple solutions mildly similar to what I am looking to do, but can't quite get it right. Feel free to link me to another solution if you feel it would solve this pro…
-
How to combine multiple rows of data into one row based off of one cell value.In Formulas and FunctionsHello Smartsheet's community! I am back with another question. I have a database that holds the tracking of employee trainings. The training structure is in tiers and after each completed tier they fill out a form. The raw data from this …
-
Enhancement Request: Ability to lock a row if if a task is dependent upon another being completedIn Using SmartsheetExample: There are Task 1 and 2 and Task 2 has Task 1 as Predecessor task. Until Task 1 is marked completed, Task 2 or some of its columns are LOCKED and cannot be edited.
-
Form required fields - preventing form submission?In Formulas and FunctionsHello! I'm wondering if anyone knows of a way to prevent a form from being submitted with empty required fields. Let me know what you know! I'm hoping there is a way to do this. Otherwise, this doesn't feel like they are truly required…Answered - Pending Review 3 views 2 comments 0 points Most recent by Andrée Starå Formulas and Functions
-
Continuously evolving Sum formulaIn Formulas and FunctionsIs it possible to create a formula or workflow that would move/update our "90 Day total" column as new months come and go? I've attached what we are currently working with. The 90 Day Total is just a sum formula for each Jun Jul …Answered - Pending Review 12 views 6 comments 0 points Most recent by Paul Newcome Formulas and Functions
-
Daily Update Solution without the need to open the sheet, use Zapier, or similarIn Formulas and FunctionsHi everyone, Happy New Year! I hope you're well and safe! I've developed a way to use the newly released Record a date feature to update sheets with today's date automatically without the need to open it or similar. 1. Add a so-called h…
-
How to input a date/time and calculate a time elapsed?In Using SmartsheetI'm brand-spanking new to Smartsheet. We are trialing it for work and I'm trying to convert some of my Excel workbooks for use in this new platform. A really common formula for my work is =(Time1-Time2)*1440 which gives me a total time el…
-
Formula not workingIn Formulas and FunctionsHi , Can anyone help me with this formula issue:- I have 4 symbol color- Not Started- Gray Not Applicable- No color On Hold -Yellow Complete- Green Act1 greater than Act2 and Status is equal to In Progress - Red else Green =IF( Status…Answered - Pending Review 12 views 1 comment 0 points Most recent by Toufong Vang Formulas and Functions
-
Return status of cell (blank vs. full) at today's date.In Formulas and FunctionsHello! I am trying to use a function that will tell me whether a cell is vacant or full at today's date. We are trying to create a desk booking system for our office, so the end-goal would be to have a vacant/occupied indicator on a SS da…Answered - Pending Review 1 view 2 comments 0 points Most recent by Clayton Richards Formulas and Functions
