-
How can I take a concatenated string and feed it into a form as an option?
Can't figure this out.. I have form with 4 fields in it. The user picks drop downs off of each of the 4 questions and saves the form. In the sheet, I have a 5th column that concatenates all of the 4 fields. (It basically builds a unique name for each of our customer audits) and looks like this.. 2019_Jun_Fab5_Skyworks…
-
reporting on update requests
Hi all, Every week I send out update requests. I get the notifications when someone makes a change but I was wondering if there is a way to actually report on the update requests sent out and which have actually been done vs those that have not been complete???
-
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
