It would be great to be able to use relative addressing in cell linking between sheets and links in reports and sights instead of the fixed linking as currently implemented in Smartsheet. Why? We use …
In short... if I pull a date from another sheet using "Link from Cell in Another Sheet", I can't do formulas off that date. I've verfied that the columns are formatted as dates. [Opening Date]1 is lin…
I'm hoping to find a formula I can use to automatically fill out the parent row's progress bar based on the child rows. The result would look something like this, just not sure if this is possible. * …
Hi Everyone, I am relatively new to smartsheets and there are two things I have been trying to work out adn for the life of me can not find the information to show how its done. The first is having a …
Each month I run a report for training attendees. I have sorted by month and have the count of attendees per month then year. I created a filter for each course that will provide the number of attende…
Is there a way to publish a sheet with the side toolbar collapsed or eliminate it, and still have edit mode to add attachments, comments, and select dates?
I have a sheet that has a status column which is a dropdown list - In progress, not started and complete. I want to return the number of rows where status is not complete. How do I do this?
I have a time/hours sheet to keep track of customers that have varying statuses. The statuses include in progress, complete, and cancelled. I currently have the sheet being sorted based on the status …