-
#CanDoCommunity Live Q&A: Learn from your peers - Smartsheet for Higher Ed
Tuesday, Sept. 15 from 9-10 a.m. PDT Join us for a live Q&A session on September 15 at 9 a.m. PDT with three Higher Ed subject matter experts from two major universities! These three Smartsheet champions hold leadership roles at The University of New Mexico and California State University - Fullerton. They oversee a wide…
-
SUMIFS with multiple OR criteria using CHILDREN?
Just curious. Looking for a way to speed up this scenario: =SUMIFS([Range to sum]:[Range to sum], [Criteria range]:[Criteria range], OR(@cell = [Criteria]1, @cell = [Criteria]2, @cell = [Criteria]3)) Is there a way to transpose that OR statement into something using CHILDREN so that I can plop a list of a large number of…
-
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.)