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
Formulas in Smartsheet
Im trying to get a formula to work in smartsheet. Can anyone help me out? =IF([Travel Type]1, "craftworker"), ".3", ".4") I want it to apply $0.30 to the cell if the travel type selected is craftworker.
Planned and Earned Value into Project
Wondering if anyone has done any formulas for either Planned Value (PV), Earned Value (EV), into their SS projects? I have all the costing,tasks, opex/capex.%Complete,dates.. in my projects and this would be my next step :)
Adding the sum of a range of cells using the IF function
Hi! I wonder if someone can help me. I have a range of cells using the IF function. I'd like to calculate that range using the SUM function in another cell, but it just comes back with the total as "0". Is there a special formula that I need to use to complete this action? Thank you
Formula with star symbol
HI, I was trying to use a formula with symbol. Here is the formula I wrote. The formula is working but I would like it to be the symbol Starred/Not Starred and not the words. My column property is symbol. =IF(Status1 = "Done", "Starred", "Not Starred") What am I doing wrong? thanks Marie
Card View
Loving Card View already, this is a real game changer. It would be great if it had the ability not to add completed rows, for example If I mark a row/action as complete I want to keep the information in my sheet although I don't want to see all of them in my view.
Print out of gantt chart is incomplete
Why is the printout of gantt chart is not printing completely. Seems a bit of words in gantt chart missed out.
Trying to change RYG based on status of a group of rows and Subtasks
so i have rows that turn red green or yellow based on progress i would like a master progress since the rows are normmaly collaped that shows over all status of a section i have code but its not working =IF(COUNTIF(Status18:Status25) = 0, "Red", IF(COUNTIF(Status18:Status25) = 100, "Green" , IF(COUNTIF(Status18:Status25) <…
Formulas
Thanks for the help!
API 2.0 UpdateRows - Partial Success
Hi Community guys! I am using version 2.0.2.0 of Smartsheet C# SDK (smartsheet-csharp-sdk.dll). When doing bulk updates via "UpdateRows" using the API in C#, is there a way to use the parameter allowPartialSuccess (true or false)? Tnx, Mike
Cardview - Add Contact List too!
Love the new card view functionality, but it would be great if card view could be used for contact lists as well as dropdown lists. I tested this using a formula in the dropdown list column (=[Contact List]), and it works, but it's not the most ideal solution. Also, how did you setup the sheet/cards to get what appear to…
