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. Archived 2015 Posts
Archives for May 2015
Discussion List
Subcontractor needs help
I'm brand new to smartsheet and I'm trying to figure out how to best structure my sheets for managing multiple projects. We're a construction subcontractor with 50-60 different projects in process at any given time - new ones added nearly everyday and other completed projects dropping off. Do I need to set up a separate…
Microsoft OneDrive for Business Support
I can't be the first one to ask for this, but OneDrive doesn't yield a hit when searched for? Is attachments from OneDrive on the roadmap?
Calendar View | Start Day
I want to be able to display the calendar view with Monday as the fits day of the week (Mon- Sun) insetad of Sunday (Sun- Sat). Is this possible?
Sumif with Children
I want to do a sumif based on the value of one column, but only get the children tasks so the summary tasks are not included in the sum. I can get the sumif to work fine; I can get a sum(children()) to work fine. However I can't find the right syntax for the =sumif(col:col, 1, children()) Does anyone have an example of…
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.
Update Requests
Is there anyway to send an update request for a particular row in which the email does not include hidden columns? My sheet that is shared has hidden columns that are locked for Editors, by using the send request the editor can now see the hidden information. Thanks Ian
How do I run a report based on multiple smartsheets with varied column headings?
When I select the "What?" criteria for running a report, it wants a number and not all columns contain numbers, some contain tasks written in text. Is there a workaround? Do column headings need to be labeled the same across all smartsheets/workspaces used to generate the report? Do separate reports need to be run for…
Past Due Reporting
Is there a method to have a report that generates past due tasks? On our task management sheet, I have a ‘due date’ and ‘date completed’. Once a task is finished, my team members will input the date completed. If the date completed extends past the due date, I would like a report to be generated and available to the…
Can you create a form that will populate a specific row and column of a sheet?
I want to gather the status on specific projects by sending a form. I would like that status to populate a specific row/column of a sheet.
Preserve leading 0's: