-
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…
-
Cell linking broke my sheet!
Yikes. I was trying out the cell linking feature now my sheet is messed up and tells me to log out and back in. I tried to delete the linked cells and save but it won't let me. I can't save or publish. I can't revert..... Reached out to support but hoping someone can help fix. formName: ajax formAction: fa_gridSave…
-
Smartsheet have Error
Dear Smartsheet team, One of our main project management sheets cannot be accessed. We logged out, logged in, restarted browser, computer, etc. The message is: An unexpected error has occurred. Error code 51 It can not be accessed by web or mobile device. Please help urgently, all our daily client projects are managed here…
-
Workflow automation
I want to alert someone who doesn't have access to the Smartsheet but instead a Dynamic View of the sheet. Is this automation possible? Marie
