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
Email Address of a Sheet
I might be mixing up this functionality with a different product but I thought Smartsheet had the capability to email a sheet and the information in that Email automatically gets added as a row to that sheet. I can't find information on it in the help documentation but I thought I remembered seeing this referenced…
Thank you!
I just want to say "Thank You" to the folks at Shartsheet. You actually listen to what your subscribers want and try your best to give us functions in Smartsheets that make our job easier and more efficent. Kudos to you!
JOIN(ANCESTORS()) example
In the Formula Help template (v2.0, line 109), there is an example of using JOIN with ANCESTORS https://app.smartsheet.com/b/launch?lx=ZRqX2Q4TSzFgNI_3hZWDkl2F3tjZfBYMX.... The formula is: =JOIN(ANCESTORS([Value 1]105), ", ") The result is: Hierarchy Formulas, Parent Row, Child Level 1 but row 91 (the 'oldest' ancestor)…
Print row vertical layout
When sending a row the vertical layout option makes it much easier to read. Is it possible to add this option when printing a row.
AutoNumber starting with zero
I would like for the AutoNumber functionality to be able to begin with 0. It seems that is currently not allowed. For example, I have meeting minutes and the first row is the meeting date. The next row(s) are the actual agenda items. It would be great if the first row became AutoNumber 0 (Which I would then format with…
Challenge with Attachments
I have been successfully attaching documents for many month now. As late as last night I successfully attached some spreadsheets. Now today when I go to attached the green status circle spins but then disappears and the document does not attach. Has anyone experianced this?
Automatically check-mark parent row when all children rows have been check-mark
In below scenrio, is there a formula or some approach that will enable new added rows to be automatically accounted by formulations on outdent rows? The purpose is to automatically checkmark the parent/outdent rows when all their children/indent rows have been checkmarked. Pls refer to attached picture “Query - Checkmark…
Automate color change on a Date-category cell
In attached scenario, is there a formula that will enable “Target Date” cell turns to red color when it is smaller/earlier than “Completion Date”? Inserting a Date category column and setting up conditional formatting gets the job done. I'm curious whether there is a simplier way. Thank you. Jon
Including pictures while sending update request from row
Hi, Please guide if there is some way I can include pictures [which was uploaded earlier on row] while sending the update request within my contacts. We are using smartsheet for construction project management and I want to update the row to contacts with pictures attached in that row. Thank you. Deepak.
Duplicating a sheet has doubled each resource usage
I have created a sheet of activities and then allocated resources to each task as normal. I then wanted to keep this sheet as is, as a template. I made a copy of this sheet to do some "what-ifs" scenarios on this sheet and keep the original intact. However in the Resource View, each resource is picking up the utilisation…
