-
Best Practices for managing 60+ projects in Smartsheet
Hello, I am a fairly new user of Smartsheet and have recently started at a construction company as a project manager where we design manufacture and erect large steel buildings for rural and industrial use. (From farm sheds through to aircraft hangers and fabrication workshops.) We have up to 70 projects active at any one…
-
iOS 13 and SmartSheet
For any Apple developers, have you tried the beta version of iPad OS, Safari and SmartSheet? I am so wanting to eliminate carrying my Windows laptop just for SmartSheet administration. The current SmartSheet apps don't allow it and neither does the mobile version of Safari in iOS 12. Please let me know your experiences so…
-
Is there a way to have a date change in autofill within a formula?
I am looking to shift the way my data is displayed so I can place it in a dashboard. To do this, I'd like to shift the information within to do a specific date and return that. My formula works fine, but I have to change the date for every single line. Wondering if there's a shortcut or something that I could do to avoid…
-
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:
