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
RYG balls automation
Hi, I went thru existing discussion but could not find my exact need. I would like to automate the RYG balls to change color based on two dates columns. For exemple if "date issued" is blank I need a yellow ball, if "date issued is not blank but "date released" is still empty then show a red ball and finally if both date…
Emailing out of Smartsheet
How do I email to one or more email recipients out of SmartSheet attaching previous Attachments that I have made on various rows in SmartSheet?
Problem with date cell being blank
I am thinking this should be easy but can't seem to figure it out and would really appreciate some help. In working with our customers, we first create an estimate with the goal of turning it to a work order if the customer decides to make a purchase. I have a column entitled 'Estimate Creation Date', and I want to have my…
Export sheet URLs to excel
Hi, I'm trying to export multiple secure sheet links (urls) to excel (or pull them into a report) so I can upload them to a field in Salesforce. Is there any easy way to do this? Thanks for your help!
Move to Another Sheet issue. Please help
Hi Team, I use a number of sheets in my business and for a company I work for. We use "Move to Another Sheet" after a job needs to be past on in the next stage of the process . "Sales" "Accountant" "Installer" etc. We find the row gets thrown down the bottom and we have to "Sort Rows" A-Z then Sort Descending to get all…
Count, sum, average
I use Smartsheet to track employee certifications. I'd like to determine the average number of certifications per person at each site/area. I'm able to use an equation to determine the number of certifications each person has, but that occurs in each row which throws off the average. In other words, =IF(Status1 =…
Symbols and Dropdown list
Is there anyway to associate dropdown list with symbols for display in card view?
Creating dependancies so I can change my start date
I am setting up a project plan but at this time I am not sure what my start date is. I can set it up with a possible date and create my tasks and dependnacies. But how can I make sure my dependancies are set up correct so that when I change my start date everything will fall into place.
Is anyone using an Air Pen or scanner to add data to a sheet?
We'd like to enter data from hard copy files into a sheet. We've found air pens or scanners, but we're not sure if we can use them with Smartsheet.
Anyway to disable keyboard shortcut ctrl+1?
I use chrome and I use the keyboard shortcuts for switching between tabs. The first tab from the left is accessed with ctrl+1, but in smartsheets this hides and unhides the toolbar. Is there anyway to disable this functionality so I can switch to the first tab quickly? I use pinned tabs so I can't make shartsheets the 1st…
