Join the Smartsheet Community
Find answers to Smartsheet questions, learn about project management best practices, discuss the future of work management, and get how-to guidance for every Smartsheet use-case from fellow users and Smartsheet experts.
Discussion List
-
Report showing parent task?In Using SmartsheetHello, I would like to get a report showing the parent tasks. Is it possible? Thank you
-
Net duration between 2 dates AND hoursIn Formulas and FunctionsHi, I use this formula to calculate duration in minutes between two dates and time (see picture attached). Goal is to time delay of response between reception of email and answering email but to exclude hours people are not working. Here i…
-
using priority with Today functionIn Formulas and FunctionsI am trying to use priority symbols for two separate date columns to report "high for 60 days out, "Medium for 180 days out, and "Low" for everything else based off the two columns: Landlord Notice Date and Expiration D…
-
SUMIF HelpIn Formulas and FunctionsHello! I am trying to come with a total number based on region and type of project. For example, the project type is new product, the region is APAC and the 1yr rev is $1M. I need a metric where the formula captures the same region, the …
-
2 variable function in a formulaIn Formulas and FunctionsHello! I have 2 variables that determine what the returning value is. First variable would be Name (row), second variable would be Score (column header). The Score value in the formula is a variable and is determined by data entry. For i…
-
Alerts only partially workingIn Using SmartsheetThis is a slight variation on the "Alerts not working" or "Alerts stopped working" questions that pop up frequently. In my case, the alerts stopped working and I finally figured out that if I created an alert *that did …
-
Error Code on multiple scripts - PLEASE HELP - URGENTIn API & DevelopersRequest failed for https://api.smartsheet.com returned code 400. Truncated server response: { "errorCode" : 1012, "message" : "Required object attribute(s) are missing from your request: values.", "refId&…
-
A way to document the last time a linked sheet was modified?In Using SmartsheetHello! I have a master project sheet with other sheets linked to it. I am looking for a way to have the master sheet document the last time each linked sheet is modified. On the attached screenshot, column titled "Project Plan Stage&…
-
I would like to have my formula simplify. I am not great with adding and/or to my formulas.In Formulas and Functions=COUNTIFS({COLLECT PLANT EXHANGE TEMPLATE ENTER STUDY}, [STUDY NUMBER]@row, {COLLECT PLANT EXHANGE TEMPLATE ROOM}, [ALL COPY]@row, {COLLECT PLANT EXHANGE TEMPLATE Range 5}, [REF DATE]@row, {COLLECT PLANT EXHANGE TEMPLATE TYPE 1}, [TYPE OF …
-
Notify someoneIn Using SmartsheetHello, I have a sheet that is updated on a daily basis using the "comment" feature. I have a manager who needs to be able to see the line items that are not updated that week. Since the only field that is being used in the shee…
