-
How do I get the exact number of Years based on the date column (no more rounding up)?
Hi there! Can anyone kindly please help me with this - I'm new to SmartSheets and having trouble working out formulas… In one column I have dates that Volunteers started volunteering with our company. The second column I used the following formula to get the number of years that it totals: =YEAR(TODAY()) - YEAR([Vol Start…
-
Interactive Graphics
Here is my goal: I need to create an image where the image has multiple areas. If one clicks on the that are (much like an image map in HTML). Then I need a secondary window to open where the use would select the status on that area. In Progress, not Started, Complete. But also I need it to show the last note added to that…
-
Reporting by month
Hello! I'm creating a reporting dashboard from a Smartsheet that tracks all incoming project types and I'm hoping to report a breakdown of the number of projects that are due each month. Is this possible with a particular formula? I'm coming up with a lot of errors. Thank you!
-
[Critical Error] Owner of the sheet can't edit despite having a Business Plan Member seat
Hi, I’m the Owner of several sheets, but I’m currently being treated as a "Viewer" and cannot edit anything. The Issue: Even though my Seat type is correctly set to "Member (Paid)" (as shown in the attached screenshot), I have no editing rights. System Error: On the User Management page, multiple error messages saying "We…
-
Free Functional Specification Templates: The Roadmap to a Smoother Development Experience
Hi. I am a new user. The Smartsheet website proclaims it has templates for functional software specifications. I can't find anything. I also can't find any resources or training videos on the smartsheet.com website or youtube on how to use smartsheet for capturing user stories and requirements. Can anyone help me out here?
-
starting out
I have no idea how to start the program. I need the basics on how to build charts and graphs.
-
Adding New Task After Setting Baseline
Smartsheet Community: Once The Baseline is Set. It Would Be Nice to Have The Ability to Add New Tasks and for those Tasks to be Added to The Baseline without Re-Setting it. Today, I have to Manual Change All the Dates. This Drastically Increase human Errors and is Very Time Consuming.
-
Display Multiple Dates as Milestone in Gannt View / Timeline View in Smartsheet Reports
Hi, I have a query regarding the display of multiple dates from different Columns (5-6 Columns) from a report in Gannt View / Timeline Row within a row. Basically, Gannt of Gannts showing multiple projects in each row showing multiple Dates i.e. Gate Review dates in same row.
-
Automating date tracking and reminders
Hello, Im building a long-range fiscal quarter date tracking sheet with preloaded due dates over multiple years . I need reminders to notify the assigned person only when the item is active , still unsubmitted, and within 30 days of the due date. I also want to avoid excessive reminder frequency. Also i want to generate a…
-
How to Copy and Compare Column Dates from Separate Sheets into One Sheet
Hi. Goal1: For project management purposes, I am trying to compare project "Current Start Date" column in one Smartsheet (SmartSheet #1) against a "Q2 Start Date" column from another Smartsheet (Smartsheet #2). This is to compare the latest/daily Current Start Date against the Start Date that was planned in Q1 for a list…