-
Assistance with IF AND Formula
Hello, I am trying to create an IF AND formula and get stuck after a certain point as I am a bit green when it comes to Smartsheets. What I am looking to have it accomplish in general terms: IF the status is set to High AND the Status is marked as Complete, then input Today's date in the Completion Date column. Can someone…
-
Nested IF
I cannot figure out why this formula does not work. HELP! Thanks. Suggestions: =IF([Complete]1 = 1, "B"), IF([Finish]1< TODAY, "R"), IF([Finish]1 >= TODAY(+45), "Y"), IF([Finish]1 <= TODAY(+90), "G", " ")))
-
New Multi-Select DropDown Buggy?
Has anyone else experienced the newly-released multi-select option being buggy? I seem to have 50/50 luck when I attempt to select from the drop-downs when it wont display drop-downs. I thought it might have just been me but then I had the (not) wonderful experience of showing my VP the new feature when it didn't work on…
-
Using COUNTIFS to Compare one Column for Blanks and One for Data
Greetings =IF(AND(NOT(ISBLANK({Date In Service})), {In Service Zones}, Zones1)) I'm trying to compare one column that shows install dates and one that has an actually name in it. Is that possible?
-
Report view and permissions
Is there a workaround to allow colleagues to view and edit cell data(non licensed)and interact within reports created from a master data sheet, without having permission to view the master source sheet? The report is created to only include columns and rows that do not contain sensitive or confidential data contained in…
-
Form where a signature can be added
Hi, my boss would like to create a form that would be sent to an employee when they make an error. The employee would review the document and then need to sign it. Like a Doc Sign document/form. Is that possible or does anyone have a work around suggestion. Thank you Raelyn
-
Sheet Sharing Question
I have a master sheet of data that feeds a number of sub sheets. I need to share one of the sub sheets with someone that can't have access to the master sheet. When I share the sub sheet with this individual, they cannot see the data on the sheet, and I think that is because they do not have access to the master sheet. Can…
-
Conditional Formatting with multi select dropdown list
When using Conditional Formatting, I want to make my primary column change colors when a combination of choices are made in a multi select dropdown,. What it looks like now is this: If column 2 is 'condition' and column 3 contains 'condition one' or 'condition two' then apply this format to the column one Is there a way to…
-
cannot open smart sheet folder "careline 27/08/2019"
got error smartsheet. Already log out & log in but same error. other smart sheet folder can open. only for folder "careline 27/08/2019" cannot. can refer attachment below. Please advise? .
-
An Error has occurred in Smartsheet
Dear Smartsheet team, One of our main production management sheets cannot be accessed. We logged out, logged in, restarted browser, cleared cache, computer, etc. The message is: An Error has occurred in Smartsheet It can not be accessed by web or mobile device across all our users. Please help urgently, our daily…
