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 2016 Posts
Archives for December 2016
Discussion List
IF formula
May I please ask assistance to help generate the following IF formula. Depending on what number value is in column 1, I want the column 2 to it to return a certain value. If in column 1 the value is >980 then return the value in Column 2 to "Excellent" If in column 1 the value is >950 but less than 980 then return the…
How to use end date and percentage complete to automate RYG status
Hi everyone, Maybe my brain is struggling with IF and AND statements, but this is defeating me. I am trying to use the end date of a task compared to today's date and the percentage complete (great than or equal to 75%) to drive my status column of red, yellow, green balls. I think I need to find a way to combine the…
URL to attachments
Is there a way to create a URL from a smartsheet attachment?
URL direct into Card View....or make card view the primary view?
I have a lot of team members who struggle with new tools. The card view is VERY easy for my team to navigate and quickly shift items around. The problem is that the link I provide for them to access the Smartsheet always defaults to the standard spreadsheet view. I get calls of confusion because they forget how to toggle…
Average If Formula
Is there such a thing as an Average If Formula in smartsheet? so to average only cells that meet a certain criteria?
Export from Tableau into SmartSheet
Hi all, I am aware of an ODBC connection that allows us to display SmartSheet data in Tableau dashboards. Is anyone aware of a way to export data from Tableau automatically into SmartSheet? (i.e. - the reverse flow of information to the existing SmartSheet-Tableau interface). Perhaps someone else in GE has developed…
ROW ID
Is it possible to create a formula that populates a cell with the ROW ID? This is to set up some triggers using zapier
Widgets do not make it into reports
I am pulling a report on a project that has a progress widget. It is a status bar. When i pull the report i get he list below. Why is that? I am assuming this is a bug? In fact, now that i think of it. I think the widgets used to be there but now they are gone after the update. Three Quarter Three Quarter Empty Half Three…
Weighted Percentage for Parent Rows
Instead of an even roll-up - can the parent percentage be set to a specific value relative to the project - see my example below; 1. (Project) Big Steel Project - 100% 2. (Parant)Steel Box - 50% 3. (Child) Bottom 70% 4. (Child) Sides 30% 5. (Parant)Steel Post - 30% 6. (Child)Short Posts 20% 7. (Child)Long Posts 80% 8.…
sort save and undo
Can I raise a serious flaw in Smartsheet. Saving after sorting can not be undone. This is a big issue for large sheets containing data. I have a client who inadvertantly saved after sorting and now had to spend 2-3 days redoing all the inputtng for the sheet in the format they wanted. The workaround we had AFTER we fixed…
