Recent Discussions
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
-
Announcement
New Forms Custom Branding and Styling, available now!In Product AnnouncementsHi Community, We launched some exciting updates to Forms today at ENGAGE! In case you weren’t able to tune in, we wanted to share them more broadly with our online community of form users and builders. So, what’s new? You can now customi… -
Announcement
Welcome to the Smartsheet ENGAGE After Party! 🎉In ENGAGESmartsheet ENGAGE 2021 just wrapped, and if you’re not ready for the fun to end, you’re in the right place! Now that you have the inspiration and the ideas for what you want to build next, we’re here to help you get it all done. Consider … -
RAID MetricsIn Formulas and FunctionsI'm trying to figure out how to build a formula using the COUNTIFS function that will count the number of ACTION items in our raid log but only if those items don't have one of our multiple closed status's. ONLY Active items if you will. …Answered - Pending Review 6 views 9 comments 0 points Most recent by Tonya Baut Formulas and Functions
-
Hyperlink PropertiesIn Using SmartsheetHi Can Smartsheet be used to link to an existing file or document on the web (Not to another Smartsheet document)? Grateful for any assistance.
-
Formulas within conditional formatting?In Formulas and FunctionsI believe this must be possible, right? I have two column 2 my on hand amount and column 4 my par. I want the row to highlight red if the on hand amount is less than the par. Tried to use @row within the conditional formatting but it seems…Answered - Pending Review 8 views 1 comment 0 points Most recent by Jason Duryea Formulas and Functions
-
I'm trying to find the number of cells that meet a criterion within a specific date window.In Formulas and Functions=COUNTIFS({Access Request Range 5},>=(2021, 7,1),{Access Request Range 5}, <=(2021,9,30), {Access Request Range 2},"Approved")Answered - Pending Review 8 views 1 comment 0 points Most recent by Jason Duryea Formulas and Functions
-
Viewing real time collaborators sheet updatesIn Using SmartsheetI have a Smartsheet that has be shared and is in use with others in our business. My problem is I am unable to see any input to the sheet that has ben done. What do I need to do to see this. Thanks
-
Determining SmartSheet access method email+password vs Microsoft (Azure AD)In Using SmartsheetIs there a way to show what method users are using to log in? I want to ensure all our internal users are using Microsoft (Azure AD) as the login method rather than email+password and it would be useful to know who is using which method. I…
-
Basic question on COUNT formulaIn Formulas and FunctionsHi - new to SmartSheet, so forgive the basic question. If I just wanted to count the values in the rows that are blue and NOT the child rows, how would I go about doing that? Thanks in advance.Answered - Pending Review 9 views 1 comment 0 points Most recent by Jason Duryea Formulas and Functions
-
Two criteria to enter text into a cell - automation not working - use formula insteadIn Formulas and FunctionsHi! I need to have text entered into a cell based on two criteria: a cell being completed and another cell being a date in the past. I have tried automation and it's not working. Maybe because I have formulas in the cells I'm referencing? …Answered - Pending Review 7 views 1 comment 0 points Most recent by Jason Duryea Formulas and Functions
-
change cell value based on a predecessor rowIn Using SmartsheetHI. Is it possible to change a cell value based on a change in another row? The sheet i am working in has a column for task status (Normal, Critical, Complete, Waiting on Contingency). Some rows have predecessors. A row with a predecessor …
-
Formula IF and NOT ValidationIn Using SmartsheetI am trying to check a flag when two conditions are met: End Date is past Today's Date Status is NOT "Complete" I am sturggling with this for some reason and cant see where I missed something: =IF((TODAY() > [email protected], NOT(Statu…
