-
From End Date Calculate Start Date
a date function that start with the "due" date(end date) and total hours to calculate the start date
-
Joyful Animations - in Smartsheet!
I am proposing bringing a bit of pizzazz to Smartsheet by having celebratory animations for certain criteria. Think Joyful Animations in Outlook! My team was hoping to have some sort of confetti pop/gif/image when we close out a project or hit a milestone. Bonus points if it is configurable like the automations are.
-
Post Dashboard Demo Questions
I always get the same question after I do a dashboard demonstration. 😂 "How do I export this to Excel?" What are some questions you get after demonstrating a Smartsheet dashboard's capabilities?
-
Has Anyone Found Success Using Both Smartsheet and Microsoft Power Platform?
Hi everyone 👋 I work for a mid-sized company (~5,000–6,000 employees) that’s heavily invested in Microsoft technologies — we use Power Apps, Power Automate, Power BI, and more. At the same time, Smartsheet is widely used across our teams, especially for project tracking and collaboration. Right now, we’re in the middle of…
-
MS Project vs Smartsheet connectivity
I have a project that is run in MS Project (Desktop) on clients SharePoint, which we also want to have in our Smartsheet account so that we can track the progress and allocated resources, without duplicating efforts on updating both. I have found this can be done via Data Shuttle (which supports desktop version of MS)…
-
Absolute Sheet References for use in formulas across multiple sheets
We use our own variation of the Project Management Template Set, and our PMs copy the folder when they are initiating a new project. We would like to include a formula in the project plan template for which the reference to another sheet will persist and work in the copy. This will help so that the PM doesn't have to…
-
Project Cutover Planning
I have been working to transition my Excel based cutover plan to Smartsheet. I have read the posts about the challenges with Date and Time and having the ability to calculate duration with these challenges. Has anyone identified a truly viable option to track tasks at the minute, hour and day level for both child and…
-
IF AND OR not working properly, last IF not triggering anything
Please help me figure out why this is not working: =IF([% Complete]@row = 1, "Completed", IF(AND([Start Date]@row <= TODAY(60), [% Complete]@row = 0), "Not Started", IF(AND(NOT(ISBLANK([Start Date]@row )), NOT(ISBLANK([% Complete]@row ))), "In Progress", IF(AND([Start Date]@row >= TODAY(61), [% Complete]@row = 0),…
-
Best Practice Inquiry
Good morning, We have an expense report that I pull from our system 2 times a month and put into Smartsheet. I have about 100 Department IDs I share it to split between different 10 bureaus and 4 centers. I am trying to find a good way of splitting up the information. Currently I have 10 grids for the different bureaus…
-
How have you secured buy-in from other departments (business, sales, etc) to use Smartsheet?
Hello! Any tips and tricks to encourage the other departments (outside of Project Management/PPM) to use Smartsheet?