-
Ability to Adjust Axis Maximum
Hello, I'm opening a new discussion since the old version hasn't been responded to in some time. Stacked graphs are for some reason adding cushion on the ends. Is there no way to top these out at a certain number or percentage? In my case, I'd like to stop the percentage at 100%. Can we at least know if this is a priority,…
-
nested ifs with greater than less than- #unparseable
Wrestled with this enough. Need to call in a friend. Can anyone figure out what is wrong with my formula? =IF([Last review date]1> 365), "Red", IF(AND([Last review date]1 < 365, [Last review date]1 > 275), "Yellow", IF(AND([Last review date]1 < 275, [Last review date]1 > 0), "Green", "")))
-
Reminder Escalation
Hello there! I set a reminder in the grid view to inform the project owners of the 4 teams that they know before the start date, if they don't change the status to "Complete", they will be reminded every 3 days, if they change, it will no longer Remind. Now, I want to set up an upgrade reminder based on the previous…
-
Subtracting dates
I have an excel sheet that subtracts dates. The formula is as follows: =IF(P4="","",NETWORKDAYS(P4,Q4)-SIGN(NETWORKDAYS(P4,Q4))) This formula works. When I use it in Smartsheets, the formula is as follows. =IF([POC Date (Planned)]3="","",NETWORKDAYS([POC Date (Planned)]3,[Actual/Pending Date]3-SIGN(NETWORKDAYS([POC Date…
-
Importing excel IF/And statments to Smartsheets
I use the below IF/AND statement in excel. It works fine. =IF(O4="Close","",IF(D4="","",IF(AND(M4>0,M4<=0.1),"YELLOW",IF(AND(M4<=0,M4>-0.1),"GREEN",IF(M4<-0.1,"PURPLE",IF(M4>0.1,"RED",)))))) When I import it into Smartsheets, the formula is below and doesn't work. I get #UNPARSEABLE in the cell. Does anybody know why the…
-
Linking & Formulas
I would like the information from the first document labeled template first to auto populate into the second smartsheet labeled template second. I am managing multiple projects at once and have 7 smartsheets to track the data specific to each of those projects. I have 1 master smartsheet which houses meeting information,…
-
At Risk Flag - Past Due
I want to use the "At Risk" Flag to populate when an item is not marked complete and is past due. I assume I need to use an AND or and OR formula - but this isn't working. The formula below yields no populated flags. The line for "Tag Drawings" should populate a flag because it is past due and is not completed.
-
Japanese text gets garbled when exported into PDF/PNG.
Hi please check the attached. I put some text in Japanese and tried to export the whole gantt into PDF/PNG. But what I see is the garbled texts for Japanese. I think this is a bug; can you fix this asap? Thanks, Koji
-
Roll Up Works REPORT only partially
Hello, I know that reports have been an issue, but I think I have a strange problem. My reports are not refreshing with the latest data, even hours after the Roll Up sheet (on which the reports are based) is updated. When I go to my Roll Up Sheet (on which the report is based), and scroll all the way to the right (as if I…
-
Formula to determine row number
Hello, I am wondering if there is a way to determine the row number of a specific row. I know this can be done in Excel with the row() function. This does not work in Smartsheet. The reason I am looking for it is because I have a formula that needs to apply to every row that checks the row above it, but that fails when it…