-
Columns Moving Automatically
Has anyone had any issues with column headers moving around the sheet automatically. I have multiple sheets referencing each other using vlookups to report back and also to use tools I have created. Therefore the location of certain columns are highly critical to my companies daily workflows. I have already confirmed that…
-
My client, an unlicensed user is not receiving their validation code
Sorry for such a basic question, but I have looked every where and reached-out to SmartSheet support. My client, an unlicensed user is not receiving their validation code to access the smartsheet I've created as a licensed user. The code is not in their junk or spam folder. Any thoughts on how to fix this? They've followed…
-
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),…