-
Formula - IF and VALUE function
I'd like to figure out how to execute the following function. If a cell contains certain text, fill in a numerical value in another cell. For example: If cell A1 says "Request Type A" then fill in "3" in cell A2. If cell A1 says "Request Type B" then fill in "5" in cell A2.
-
Percentages
Is it possible to have .5% as a percentage. Whenever I put .05 it rounds to 1% and .04 rounds to 0%. Thank you
-
IF/AND Statement with CountIf
I'm trying to create a formula that will look at my "Measurement" column for the text "PBI" at the beginning of this formula: =IF([Rank/Actual PTR]434 > [Score/Goal PTR]434, "PTR Exceeded", IF([Rank/Actual PTR]434 = [Score/Goal PTR]434, "PTR Met", IF([Rank/Actual PTR]434 < [Score/Goal PTR]434, "PTR Not Met", ""))). So, I…
-
automatically move date from one column to the next
I wondering if there was a way to move data from on column to the next when information is inputed into another column. For example if I create a column in front of wk 1 allocation% and input a %. I would like week 1% to move to Week 2, week2 to move to week 3 and week 3 to move to week 4. Week 4 can just go away or I can…
-
Displaying multiple column values in Calendar view
I am storing data related to issues in the smartsheets. How can I show the issue number and priority in the calendar view?
-
ERROR: a resource is busy or you lack sufficient access rights or permissions
Hello, I am unable to take an email document stored in smartsheet and save to box. I have tried to download the email, save it to computer desktop and receive the error. "a resource is busy or you lack sufficient access rights or permissions" I have tried to download the email document and while the email is open chose…
-
Coping Dashboard
Is there a way to copy or save a dashboard as a template. Instead of having to make new ones from scratch?
-
T-shirt size icons for visual icons?
Would love to have S/M/L T-shirt icons to visually look at sizing. This would be helpful as a project manager and on a scrum team
-
Formula Needed for Parent to Inherit Child Value
I don't think this is possible, but I need a formula where a parent row Status value reads "No Active Projects" until it has a child row below it with an "In Progress" status at which point the cell should just be blank. See image below. I use the "No Active Projects" marker to determine whether or not that department…
-
Sum ifs 3 criteria
I'm looking for the sumifs= Status column is "green", The Trans Date column in January 2018 the reversed column is unchecked. So far I only have the first part of the formula working. I cannot figure out how to include the rest =SUMIF(@{Collections Range 3}, @cell = "Green", {Collections Range 1}) This information will be…
