Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Discussion List
Formula To Ignore Zeros In Averages?
I have columns running left to right with the 12 months listed as the main header of each. I want to have a column on the far right that shows our average month's sales based on each months totals we go. RIght now it is May, but the simple AVG formula also counts June-December sicne they have zeros in them. So, instead of…
Alerts for Non shared users
Is there any way we can send alert or reminder to user which don't have authorization to sheet but email id appear in a contact list
Linking for resource tracking
Hi, I'm using rows linking when one task is needed for different projects. The Allocation % field is linked as well in such situation. The problem is that Smartsheet treats linked allocations as two different tasks and adds allocations, instead of reading Allocation % only from the master sheet. Do you have a solution how…
Default view when opening a 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 the sheet? Thanks Ian
linking cell data across multiple sheets to capture changes made on master sheet
ex. Master Sheet - all changes, updates and final information Trailer Sheet - info from Master gets copied to trailer Avail Sheet - info from Master gets copied to avail Is there a way I can ensure that my data changes on the master sheet are rolling up on the alternate sheets that house the same data? Thank you Tanya
Misaligned column headers
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.
Resources for new users? Smartsheet has you covered.
Smartsheet has a great (and hilarious) video that highlights the variety of resources out there for new users. It's 2 minutes and 40 seconds of wisdom. Help us get the word out by sharing on your social channels.
Is there a way to update a submission?
If someone submits a form, is there a way they can update that submission without submitting a new request?
today() function
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 clicked? Thanks, Shaun
Emailing report or report link... what schedule options?
I have set up reports so that users will only receive notifications on rows tied to them. What are my scheduling options? Can I have the report sent when a change is made? Or does have to be sent once a day (or whatever the schedule you pick) whether there is a change or not?
