Join the Smartsheet Community
Find answers to Smartsheet questions, learn about project management best practices, discuss the future of work management, and get how-to guidance for every Smartsheet use-case from fellow users and Smartsheet experts.
Discussion List
-
Formulas for % Allocation in Resource ManagerIn Using SmartsheetIs it possible to use a formula to generate a percentage in a % Allocation column for use in the Project Resource Manager? Or does a percentage have to be manually entered into the % Allocation column? I've done quite a bit of research on …
-
Greyed out Baseline FunctionalityIn Formulas and FunctionsI have an issue with greyed out Baseline Functionality and I pay for a TEAM Plan which I think is better than an Individual Plan but lower than Enterprise or Premier. How come I can't s access the Baseline feature even when I am owner of t…
-
Notification Email: Send to Contacts in a CellIn Using SmartsheetThe below form was built that when it is approved you will have 3 email alert notifications (i.e. 1. facility lead contact email, 2. HR contact email and then a set of 3. recipients). Would you be able to show me how I can use the HR conta…
-
Greyed out baseline tabIn Formulas and FunctionsHi, I'm trying to make use of the Baseline function, but it's greyed out. I'm in the Gannt View and also the owner of the sheet.Answered - Pending Review 13 views 2 comments 0 points Most recent by Charles Fombrun Formulas and Functions
-
Form Fields Out of OrderIn Formulas and FunctionsI have created a form with with about 30 fields. I have set up some automated update requests. When the person receiving the update request link opens up the link to the form, all the fields are not in the order I set them up in. Any ideas…
-
Any formula, if duplicate, say: "Duplicate"?In Formulas and FunctionsAny formula, if there's a duplicate in this column, say: "Duplicate"? Thank you!
-
Using decision symbols: Yes, No & HoldIn Formulas and FunctionsHi all, Understand that this has probably been answered before however I can't quite find the solution I need and have spent a little too long trying to get this sorted. I need to display Yes, No or Hold symbols with the following paramet…
-
COUNTIFS using Dates and IFERRORIn Formulas and FunctionsI'm trying to replace some formulas in a summary sheet that I accidentally wiped but I cant seem to get them to work and I know I'm missing something but I'm not sure what. What I'm trying to count is all the dates listed in the year 2020 …
-
IF Function Question - Symbol changes with dateIn Formulas and FunctionsHello, I have been having some issues configuring a formula in smartsheets. I am trying to write a function where the Symbol (Green, Yellow, Red, Grey Balls) in the 'Status' column adjusts according to date in the 'Start' column. Green a…
-
Gantt chart - date fields ok from formulas?In Using SmartsheetHi, all. I have data in table where two date columns are derived from formulas. When I try to use the Gantt chart functionality it says that my grid needs at least two dates columns and doesn't allow me to continue. I have two date columns…
