I am trying to make a rule that when I am finished with a cell and change a status on that cell it will then transfer it to another sheet. In short when I am finished with a project and have collecete…
In the Home tab, how can I locate sheets in different folders or workspaces*? For example I would like to be able to access a sheet from any folder "Geographic\USA" and "Pharma\Dermatology" because, s…
My Smartsheet keeps resetting to a seemingly random sort order each time I save. I've manually resorted the sheet using two criteria (the main column--Author--then another column--Title) but when I sa…
Can't figure this one out. Hoping someone can help. I have 6 sheets for various projects we are working on. Each sheet has at least one level of heirarchy and some have up to 3 (parent/child/grandchil…
Is there a convenient way to assign a fixed reference to a record that remains the same even if new rows are added or deleted anywhere above the record? Something like linking cells from another sheet…
Is there a way to set a default view when I open a sheet? If I only want some children rows displayed and others collapsed, can I set a specifc default layout that will open that way everytime I open …
How do i realign columns and columnn headers in a large sheet? They appear progressively more staggered across the page. Here is a shot of the page about half way across, Very confusing! Thanks, Ray.
I want to create a formula tht creates a Datestamp of when a checkbox is clicked. If I use the today() function the date will keep going up. Is there a way to lock a date to the day a checkbox is clic…
Hoping someone can help puzzle out a way to make this work! I'm trying to find a way to show the original estimate at the beginning of the project compared to the updated estimate based on how the pro…
