-
Request an Update Works Sporadically
I have a sheet where I have 18 different school site managers set to receive Request an Update emails when a new row with certain criteria is created. I essentially made one automation and then copied it 17 more times, changing the school name and the email recipient. The automation only works randomly and I can't figure…
-
Two IF functions for one cell
Hi, Need to do the following: If Cell B has a date within the next 30 days, Cell A will output CHECK QUOTE VALIDITY. But, if Cell C is checked, leave Cell A blank. I have the following formula already in Cell A. What should I add to have the above? =IF(AND([Quote Validity]69 >= TODAY(), [Quote Validity]69 <= TODAY(30)),…
-
Project sheets roll up into a Program sheet, with bi-directional syncing of worksheets.
I am looking to have sheets have a bi-directional sync between worksheets. Wanted it to be more of a Parent/Child relationship, where the Parent sheet can have 1 or more Child sheets roll up into it. While allowing the editing and syncing of each child sheet by both sheet editors. Scheduled or near real-time bi-directional…
-
Request an Update Form
Hi All, Can I send the send column (cells) to the two persons to request the update at the same time? I tried and it looks like only one person can update and the other person cannot update. The picture below is the one I can actually type in and update. Same thing for the other person was not able to do anything. Thank you
-
Onboarding/Offboarding
Hello All. I was wondering if the following was possible: We have created a Master Onboarding/Offboarding sheet (information is captured using a form). The first question on the form is they type of request (Onboarding or Offboarding), from which logic is then captured. If Onboarding is chosen, one of the questions is "Are…
-
Schedule Form Deactivation & Friendly Form Ended Msg
Hello all, I've searched this topic but only found old ideas from 2019'ish, so I'm hoping there has been an update made to Smartsheet or someone found a better workaround (meaning user friendly) than what was previously suggested. 1) I'd like to schedule a form to deactivate at a set date/time. I'm not seeing that as an…
-
Capture data in different columns
I would like to be able to separate the options of a multiple type column into different columns, for example, if a drop-down list with multiple selection "Texas", "New York", "North Carolina", "South Carolina" can be placed in the column ", then I would like to be able to have those three words recorded in different…
-
Find Percentage Formula for Smartsheet Summary
I have two summary lines that have formulas in them and the results in both are numbers. I want to find the percentage (first number divided by second number). The first number shows how many "tasks" are complete while the second number shows how many "total tasks" exist. I've not had any luck with any formula combinations…
-
Can I import a functional Excel sheet with drop down data
I currently have a sheet that utilized drop downs in EXCEL. I choose a cell, the drop down has data, I pick the data from the from down list and it populates the cell and a formula in the cell additionally populates another cell with a value. Can an imported excel sheet work in this way? Would I have to rewrite the sheet…
-
Workspace Permissions vs Content Permissions
If someone is the owner of a workspace but I own files within that workspace, and then I'm removed from that workspace, what happens to the files? Does the workspace owner become the new file owner and I lose access?