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
Round down fomula
I would like to round down the figure into thousand. However, it seems there is only a Round function but to Round down. How can I make it happen? Thanks
Conditional Formatting Not Working
These conditional formatting rules are not being applied to my sheet for applicable rows. Does anyone have suggestions?
Sprint Name field
How can I get the Sprint name field to pull from Jira to Smartsheets? The Sprint field is not showing up as a field in the Jira + Smartsheets connector for me to sync.
Formula for a dependancy
I have 5 columns on a sheet that all have check boxes. Is there a formula that will say If these 5 boxes are checked then they have the status of green dot?
Automate Child Row Based on Parent Row
Hello SS community. I am curious to know if there is a way to update a child row based on a parent row. My real world scenario is as follows. I move children rows physically on the page into one of 6 sections contained by parent rows. When I move a row into the 'Completed' section, I would like the status column to change…
Hyperlinks in Smartsheet
Is it possible to configure the Hyperlink in Smartsheet to open a local program in my computer like what we do normally in Excell ?
Date and time stamp updated by day light savings
We have a number of Smarttsheets that are populated by web forms. The date and time stamp information that was entered prior to day light savings have now changed to reflect a "fictional time". In other words, an entry that was added at 6:00 am two weeks ago, now show a 5:00 am entry time. We need the historical…
Invite showing as expired when clicking accept
Just setting up our account and sent out the first batch invite to our users. I am getting a high number that are saying when they click accept it comes back saying the invite has expired. See attached file for exact message. Have tried to resend to the individuals but still the same issue? Any one else run into this? VPN…
Auto numbering each line
1. Is it possible to assign the values of the number in each new line with a given step (or digit number) For example: 005 010 015 020 025 etc. 2. If I need to insert a new line between 010 and 015, I would like to be able to recalculate all subsequent rows in accordance with clause 1. And the second option is to set the…
Set a dropdown value for all selected cells
For nested items especially, it would be nice to select multiple rows' dropdown cells, right click, and set a dropdown value across all those that are selected. So, 5 nested rows whose parent's dropdown for "status" is set to "complete". I'd like to be able to select cells from that same column for the nested rows and…
