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
Start Row ID part way through a new SS
Dear SS Guru's we have a smartsheet that has been imported from Excel. and each row has a four digit 'DVS' code that i want to automate. I can create an 'auto number/created date' column but because over time some rows in the excel doc were deleted or becuase numbers have been assigned out of order they do not run…
To set RYG using a formula that considers Todays date and Completion %
I would like to set the risk RYG status column colour based on set conditions. IF % complete = 0 And 'start' is todays date to show Risk IF % complete = between 90 & 100 to show Green somethign like this but it doesn't work =IF(AND([% Complete]row# = "0", [Start]165="TODAY", "Red")) Any ideas?
Notifications with selected columns?
Is there any way to limit the columnd included in notifications? I have a sheet with a large number of columns and the e-mail notificatons are not legible due to the number of columns included. See below This is an option when sending rows and update requests, it would be nice to have this as an option for notifications.…
Create report based on parent row
Thanks in advance for any advice. I appreciate your time and expertise. I would like to create a reports that include all children of a parent row. For example, the parent row is "apples", the children rows are gala, granny smith, golden delicious and honey crip. Another parent row is pears. Children rows to "pears" are…
What happens if two people update the same cell at the same time?
What happens when two people update the same cell at the same time?
Enhancement Request - Conditional Formatting on Gantt Bars
Change the color of a Gantt bar dependent on a checkbox or other common status indicators.
Do alerts work when using Smartsheet Sync add-on with Google forms?
I am using a Google form to populate a smartsheet. I thought I could get an alert everytime data gets added to the form, but it seems that nothing is happening, even though I set the alert for "anything" and "right away." Any ideas? Does this feature just not work because it's not a real person editing the row? Thanks, Beth
Solution Guides
I just watched the webinar on the multi-sheet Portfolio Management solution. How do I a) find the Solution Guide so I can learn more; and b) lauch an instance of the Solution. As you can tell, I am a completely newbie to Smartsheet. Thanks in advance, charlie
Starting Number New Each Month
I use smartsheet as a project management operation for my office. I'm using the auto-number field to create a request number associated with the request, {YYYY}{MM}-0000. I would like the 0000 number to start from 1 each new month. Is there a way to do it other than manually entering in 1 at the end of each month?
Formula for Counting Checkboxes in a row
Is there a way to count the number of checked boxes in a row with multiple columns?