-
Multiple IF/AND
Need help. I'm setting multiple conditions to a formula, and I can't seem to get it right. My goal is to auto-calculate our development hours based on the material type. Say: If the material is Instructor-Led, and new - development hours should be duration hours/60*5.63, if existing, then development hours should be…
-
Using Smartsheet Offline
Can Smartsheets be used offline? We have an area where electronics are not permitted, but we would like to do audits of the area using Smartsheet. We'd like to fill in the information offline, then upload the information when we can move to a permitted area for cell phones.
-
Consolidating output from multiple forms onto a single line in a sheet
I am quite a new user so apologies if this is quite a simple task I have a multi stage process which relies upon collecting information from 3 different sources (for which 3 forms have been developed), but as the information all relates to a single request to procure a vehicle, which is being tracked on a single sheet, i…
-
How do I get a Gantt chart into a report
From SS Engage: 'https://www.youtube.com/watch?v=ZTcfzjq0GEE&feature=emb_rel_end jump to minute 34:38 of that video for example of how they embedded the chart, but they never said how they built the report I have one sheet referenced, I want the items of the primary column that align with initials of Column 8 to be…
-
Embed a Sheet or Dashboard on Intranet Site
Is there a way to display data outside of Smartsheet? I would like to embed data from Smartsheet on our internal WordPress site.
-
faster way to load report criteria?
Currently rsetting criteria for a report takes a minuimum of 5 clicks (what, select field, select criteria, select expression, save). I need to run a report showing 20 columns and expression for all 20 is "is blank." Is there a way to select all the field data at once and set criteria afterward?
-
Recurring Tasks
I would like to create a recurring task on a gantt chart without having to create multiple lines. I don't believe this is a feature so can I ask that this feature be put on the list for future.
-
Suggestion — Add a formula to retrieve information about the comments in a row
It would occasionally be useful to be able to access information about comments within a formula. For instance: IF(CountRowComments() gt 0, "Has comments!", "No comments") Or even, IF(GetComment(1).Contains('error'), TBD, TBD) (Don't take the syntax too literally, but hopefully you get the idea.)
-
Approval Process stopping when conditions applied
I am working on an approval process but am finding that if I add conditions that the process pauses and does not resume with the subsequent request an approval action based on the condition. I am trying to only have 1 automation for this. General Process: Request approval from reviewer #1, if approved + condition: Job No…
-
Dashboard Card View with persistent filters
I have a dashboard with two web content widgets of the same sheet using a card view. I want to be able to have one only show the completed cards and have the second only show the in process cards. I have successfully created filters that can be used but I don't want the viewer to have to select the filter. I would like the…
