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 2017 Posts
Archives for February 2017
Discussion List
Formula enhancements: Usability study sign-up
Update: The Formulas Usability test is now complete. If you are interested to have early access to Formulas enhancements and other features, we invite you to sign up for the Early Adopter Program. Here's an information sheet about the program, and here's the sign up form. Best regards, Daniel ------------- Hi all, We're…
Jira smartsheet workflow optimizations
Hello, I have some suggestions for adding to the workflows * - If a smartsheet column has the same name as a jira field directly select it in the dropdown; * - The posibility to add field templates to select in the workflow, this way you can add a predefined list from jira fields; This would make adding workflows a bit…
Alerts not Sending to Assigned To Column
I want to send a daily reminder listing open tasks to contacts listed in my Assigned To column. All contacts have been shared to the sheet as Editor - cannot share. At least a couple of these contacts are users who have used SmartSheet before. I set a conditional formula in a reminder date field to populate with today's…
Does anyone have the formula syntax to control the RYG and Gray symbols on a sheet
Does anyone have the formula syntax for this.... to control the RYG and Gray symbols on a sheet? if due date < today and % complete <> 100% then red, if due date within 5 days of today and % complete <> 100% then yellow, if due date outside of 5 days from today % complete > 1 and < 100% then green, if % complete is 0 and…
Date calculation - work days only
I found the formula for date calculation (today's date minus 2 days is =[First Test Date]5 - 2 in my case). But I want to make sure it's calculating only work or week days. Is that possible? Thanks, Jennifer
SmartSheet keeps Folding Up Sheets
Not sure what I've done to cause this behavior, but SmartSheets seems to keep wanting to close my "visible" sheet into the "..." tab even though I have ample window space. Everytime I select a new sheet, the current visible sheet folds up under the "..." tab. Is this a setting? My computer getting confused as to the width…
Resource View Possible?
I'm setting up a Sight/Dashboard for the team of engineers. I like how the Resource View shows each sheet someone is assigned to under their name, with a link to the sheet for more info. My goal is to incorporate that into the dashboard/sight view Is there a way I can achieve this for a without having to update it…
In the Android app, how can I quickly jump to the last row?
I have a sheet that I am constantly adding to and it is almost 600 rows long. Is there any way to quickly get to the last row to add new entries? I am using the Android app. Thanks, Pete
How to index + match with multiple criteria ?
Hi! I'm trying to figure out how to do the following excel formula in Smartsheet, but I am having trouble with it. Can I get some help please ? Basically what I need to do is match 3 different criteria (lookup 1 -3) with 3 different collumns(part 1 - 3) and when those match they have to give me the corresponding Time. This…
Can you average red green yellow symbols
I have rows that each have a RYG symbol and a collection of rows roll-up to a section summary. Is there any way I can have teh section summary lok at the rows and work out an average thereby automating it