-
Automate sending an email referencing a column
I have a form where the public submits information for a schedule change. Can I set up a workflow so when I mark 'complete' in a column, I can reference the column where the email is located to send out an auto response that their request has been completed? These are non-smartsheet users who do not need any access to the…
-
Move Row Workflow
I finally figured this out! Yay! But now the workflow moved rows even where the condition was not met. My Trigger was 'When Rows are Changed' 'When' was set to a specific field formatted as a Checkbox when I checked the box, several other rows with an unchecked box moved too? Can anyone help?
-
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…
