-
Average Formula Issue
Hi there, i am trying to average cells that were built up by formulas. So basically the Column 1-7 are the scores when the task is done , it will turns into 100 when the task is complete, and where the right handside column would need to average the score of column 1-7. When I tried to average , it turns out "UNPARSEABLE"…
-
If then else function for ranges of values
Hi all, For 0-8 sightings, I need the cell to display Emerging, 9-19 Developing, 20-39 Proficient, and 40+ Exemplary. What's wrong with my formula? =IF(SUM([Sightings in past two weeks]1:[Sightings in past two weeks]4) <= 8, "Emerging", IF(SUM([Sightings in past two weeks]1:[Sightings in past two weeks]4) <= 19,…
-
Counting physical inventory while removing duplication...
I'm trying to count the number of unique pieces of equipment that are on my worksite. Each unit has a specific Unit Number listed in a sheet. Units that are On-Site are indicated by a green dot in another column. The tricky part for me is, some of these Unit Numbers have multiple work orders which are listed on another…
-
if blank and if not blank then display a word
We are trying to do a check in and out smartsheet for the people on our team that travel a lot. We have incorporated Google Forms (because Smartsheet Forms is extremely limited) so that we can restrict who sees the Smartsheet. So each person has a link to their own editable google form so that they can edit their own line…
-
IF OR AND Statement
I am trying to return color symbols for in a sheet. End goal Date Null, Completed Null, or Past DATE(2020, 3, 31) = "Red" Date is Not "Yes" and Not Past DATE(2020, 3, 31) = "Yellow" Else = "Green" Here is the code =IF([Date Completed]1 > 0,IF(AND(NOT(Completed1 = "Yes"),[Date Completed]1 > DATE(2020, 3,…
-
IF Function Question - Symbol changes with date
Hello, I have been having some issues configuring a formula in smartsheets. I am trying to write a function where the Symbol (Green, Yellow, Red, Grey Balls) in the 'Status' column adjusts according to date in the 'Start' column. Green appears if the start date is 7 days in the future or beyond Yellow appears if the start…
-
How to make existing attachment and comment "Read Only"
In the created workflow after the task is complete the row is blocked. But attachments and comments are able to be corrected and deleteed. How to prevent this for blocked row?
-
Updqate request or email from Smartsheet => get an absence notification from outlook into Smartsheet
Hi experts ;-) yesterday I enthusiastically presented again Smartsheet and one of my colleagues objected: "sending emails in Outlook is much better because you immediately can see if the receiver is present or absent." Is there a way to get this information in Smartsheet, too (at least receive the absent notification sent…
-
Summarize project sheet hours by person
Is there an easy way to summarize the total hours for all tasks on a project sheet by person? I know I could use SUMIF/SUMIFS, but the problem is that I don't know how to provide it with the input criteria for the Assigned To column in a simple manner since that can be anyone of our 30+ team members. I'm sure there must be…
-
Summary Sheet Formula with multiple criteria including choices from a multi-select dropdown
Hello - receiving an"unparseable" error for the following sheet summary formula which does a summary looking at 3 different columns - Sub-LOB, ELEMENT and Status. The Sub-LOB and ELEMENT Columns are multi select dropdown columns. And for the Sub-LOB, I want to count if any of the 3 choices are applicable - MCS CR, MCS FR,…