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
-
Using Smartsheet for Knowledge ManagementIn Formulas and FunctionsDoes anyone use Smartsheet for Knowledge Management? I'm thinking of utilizing Smartsheet for this purpose ("How To" videos, templates for employees to use, ect). I was wondering if anyone uses if for a similar purpose if you cou…Answered - Pending Review 18 views 1 comment 0 points Most recent by Bassam.M Khalil Formulas and Functions
-
Using form for book appointment timesIn Using SmartsheetI want to use a form to allow sign up for meeting times. I would need the times available to either disappear after someone has selected it or be marked as unavailable automatically on the form. I thought to try locking the column after it…Answered - Pending Review 20 views 1 comment 1 point Most recent by Bassam.M Khalil Using Smartsheet
-
Alert about Community QuestionsIn Using SmartsheetHİ there ; is there any option in community about that ; when my question replied a notification will come to my mail that my question answered from someone .
-
Need to ignore text (NA) in cell referenced in a formulaIn Formulas and FunctionsI have the following formula to determine Status: =IF(OR(TODAY() > [Due Date1]@row, TODAY() > [ Due Date2]@row, TODAY() > [Due Date3]@row, TODAY() > [Due Date4]@row), "Red", "Green") It works as expected whe…Answered - Pending Review 20 views 1 comment 0 points Most recent by Bassam.M Khalil Formulas and Functions
-
Workspace vs Folder , difference ?In Using SmartsheetGood day, what are the main difference between folder directory and workspace directory ? They look like to different directory type with same functions to me and wondering if im missing some advantages for my misunderstanding Thank y…Answered - Pending Review 14 views 1 comment 0 points Most recent by Bassam.M Khalil Using Smartsheet
-
How to sum up column RGY statuses?In Formulas and FunctionsHi Smartsheeters! I am trying to sum up column RGY statuses. The formula that I use averages the sratus and I end up with either Green or Yellow. =IF(COUNTIF(CHILDREN(), "Green") = COUNT(CHILDREN()), "Green", IF(COUNT…
-
How to edit an existing row through a Smartsheet Form (Not an update request)In Using SmartsheetWe have an automation that pops up a smartsheet form for our sales agents. They speak with customers multple times. We'd like to use the form to edit existing rows (Not create new rows). The Update Request Workflow solution does not work …
-
Approval SignatureIn Using SmartsheetHi, I use SMARTSHEET because it is intuitive. However I am wondering why there is no way to add an approval signature when approving forms. I do not want to use integrated apps where I have to pay. I see a lot of comments asking how to …
-
My parent rollup is not working properlyIn Using SmartsheetI am new, so feel free to correct me if it appears I am not understanding: My parent row should show the earliest start date from the values in the child rows, but it is blank. And it is editable. I have decreased the indent, saved, incre…
-
Need to create a column that translates "End Date" Month to QuarterIn Formulas and FunctionsTrying to create a column that tells me which quarter an item will be ready in the future. I can get the Month of the Date cell easy enough but can't figure out how to do a value range that works. This works =IF(MONTH([End Date]@row) <…