-
Dropdown Multi select - ~If formula
Hi all, Been searching about this, but could not find anything so far. Hopefully you can help me. I am just starting to make use of the multi select dropdown list. So i have a spreadsheet with some information in the first few columns. Then comes the multi select dropdownlist column. And then, after that there will be a…
-
Do Smartsheet Forms have the ability to add in image files (not logos)?
Use case: would like to add an illustration/image to go accompany a question asked on the form to better illustrate the information being sought.
-
Sum of Max Value across multiple rows
Hello, I need some help working out a formula that will let me sum the max value across 2 conditions... I have a data sheet that is getting rows copied to is when values are changed on multiple project sheets and i need to have a formula on my report sheet that returns the sum of the highest value in a day for each…
-
Validating data input in a Form
I have set up smartsheets to collect data with forms for the users at our facilities. The operators check equipment and enter the data in the form. Sometimes, they fat finger it - or forget the decimal point which causes an out of spec condition and email notifications. Is there any way to validate the data and the user…
-
How can i get a group of information to autopopulate by selecting a dropdown?
Hello, I am trying to figure out how i can get 5 or more different rows to auto populate from selecting one dropdown. when I select a dropdown for example 48-3, I want it to fill out the 3 columns like the above pic. This is for a manufacturing schedule, it is all the parts needed to make the product (48-3). including…
-
Order Pipeline Model template
I'm a Smart Sheet noob and as I was watching the first Card View video I saw the Sprockets Sample which was referred to as an "Order Pipeline Model". This is very close to what I need to track our large orders of partially machine goods form overseas through ocean freight and in-house manufacturing processes. Is there a…
-
Nest IF AND OR multiple layers to get a RED or GREEN Result/Status
This is my challenge below. I spelled it out in the screen shot. I need an overall status of Red or Green based on duration correlated to phase status.... Looking for help:
-
How to set recurring reminders
I have been searching through the posts and found this formula: =IF(Complete4 = 0, TODAY(), “”) using my own column names. Each time I've tried to accept the formula, I get this error message: unparseable. Am I missing some of the formula (my Excel is rusty)? I want to have an email reminder sent daily until the task has…
-
Multiple Approvals Per Row
Hello, I am looking for a workflow solution to our document approval process. Currently we have a Confluence page where five individuals attach a picture of their signature. I would like to set up a sheet to manage approvals of several project documents. The approvals function can currently do this, however, when I send…
-
Alert Task Owner when change is made by someone else
Hello All, I have a task sheet that is shared with multiple users. I have a field for the name of the Project Manager and a field for the name of the Task Owner. I would like the PM to get an alert when the row is updated but only if the update comes from someone other than the PM. In other words, if the PM is updating the…