Project Management
Discussion List
-
Date 6 months out (to the day)In Formulas and FunctionsHello colleagues and guests. I would like to learn a forumula to retrieve a date that is exactly six months later than a known date; i.e. Jan 1 - July 1, Feb 4 - Aug 4. Presently, I'm using 182 days, which is close, but not exact. I'm also…
-
Can I hide predecessor lines in a gantt chart?In Using SmartsheetI have a complicated project with tons of predecessors. The predecessor lines connecting tasks in the gantt view are so numerous that is makes the gantt visually hard to use. Is there are way to hide or turn off not the predecessors, but…
-
Form Drop Down Populated by Separate Sheets?In Formulas and FunctionsIs it possible to connect a drop down column in a sheet to another sheet as a lookup for relevant values? This would enable centralized control of values ensuring they are accurate for form submission. Looking at articles on Data Uploader,…
-
Move row - selected columns only?In Using SmartsheetHi, We manage Intake to Archive in Smartsheet. Our Intake Sheet (source sheet), where we collect all project info, is rather lengthy. When an Intake Request has been approved, I want the row to be moved to an Implementation Sheet (desti…
-
Returning last entry in a database columnIn Using SmartsheetI have created a database that adds a new line against a date each day. From this I am building some metrics and then a dashboard which will show Daily Performance but also week to date, annual etc. I am struggling to reference the databa…
-
Deleted RowsIn Using SmartsheetRIGHT NOW: Implement a pop-up warning to alert someone and verify that they want to delete a row. You do it for unlocking rows, and that's nothing compared to deleting a row. SOON: Give us a new user level with edit access but no a…
-
How can use the Countifs function with the Today function in the formula?In Formulas and FunctionsHello, I am not sure what I did wrong in the formula that I have created. When I physically count it, I would get 23 but the formula spits out zero. I want the formula to report the number of tasks that was within the last 30 days. Here …
-
Is anyone else having trouble with the Today function?In Formulas and FunctionsHello, The Today function is not working when included in a simple IF statement. It was actually working a while ago but now it is not working. I tested it out by simply trying =IF([email protected]="2",=Today(),"") but it would…Answered - Pending Review 25 views 6 comments 0 points Most recent by John Sisounthone Formulas and Functions
-
Is the Email Notification highlight color yellow definable?In Using SmartsheetIn a standard email notification for sheet updates the changes are shown in yellow in the email body, is there a way to define that color to something other than yellow?
-
Digital SignatureIn Using SmartsheetHi all, I've searched for this topic, but i could not find directly what i was looking for. Is there on Smartsheet any functionality for digital signature that doesn't require pairing our service with another software? All the solut…
