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
-
How can you set up a workflow to trigger on a variable dateIn Using SmartsheetIn an onboading form for new hires, I want to set up a trigger to fire 160 days after the person's hire date but I'm not going to know what that is, so I can't use the date field to trigger because I'm being prompted to choose a date from …
-
I set up some automation conditions on my sheet to test but I'm not getting any email responsesIn Using SmartsheetI checked my personal settings and I am set up for notifications on sheet changes. I set up my trigger to fire on a task being modified by a date being added but it's not working.. - any suggestions? - Thank you.
-
Email Notification unsubscribe optionIn Using SmartsheetIs there way to disable the unsubscribed option for recipients from a workflow email?
-
Filter Helper QuestionIn Formulas and FunctionsHello, I am tracking communications for my project, and each row represents a communication (e.g., notify employees of changes to expense policy). I have separate date columns for "Draft Due" and "BU Review Due" and &q…Answered - Pending Review 21 views 6 comments 0 points Most recent by Paul Newcome Formulas and Functions
-
Conditional Formating on ParentsIn Using SmartsheetHello community, Some of my subtasks are children to a large task (parent in SS). I would like to find a way to conditional-format all parents-row. (Display them bold for instance). I cannot find a way to do this with conditional format…
-
Most Occurring Value Based on Multiple CriteriaIn Formulas and FunctionsOur organization is counting how often we interact with clients weekly and that process is going great. What I want to do is show who contacted the most clients during a particular week. We have a data dump master sheet and a sheet where I…Answered - Pending Review 31 views 13 comments 0 points Most recent by Billy Rock Formulas and Functions
-
Access Control on Published SheetsIn Using SmartsheetSince the latest feature update, I am no longer able to limit access to published reports to users only within our organization's Smartsheet account. It would appear the official KB from Smartsheet has not been updated either. Does anyone …
-
Matching data from one column in Project Intake Sheet to another column in Project MetadataIn Formulas and FunctionsHi so I am currently redesigning a project tracking system for a company. I downloaded the PMO template set to use to get a foundation but it will not track the data i need it to track. Basically what I need help with is I have multiple co…Answered - Pending Review 31 views 5 comments 0 points Most recent by Eric Hash Formulas and Functions
-
#INVALID OPERATION is trying to break meIn Formulas and FunctionsThis formula is wrecking my day so I am waving the white flag and asking for help... I am attempting to display the LOG 2 "Title Company" where the LOG 1 FC Start Date (020) .GT/ET. the LOG 2 "Effective Date" and LOG 1…Accepted Answer 11 views 2 comments 0 points Most recent by Rebekah Valdez Pound Formulas and Functions
