-
Setting character limits on SS Cells or form area
Does Smartsheet allow you to set a restriction on the amount of characters allowed within a cell or in the txt box within forms? Thank you
-
Sequential Numbers "IF"
I have a project management template that I am trying to set up with a column to produce sequential purchase order numbers only if a column named "ORDER DATE" is populated in specific category rows I have named "ORDER MATERIALS". Can this be done? I am not too good at formulas, so the more specific, the better for me in…
-
Enhancement Request: Auto-Refresh Functionality
I would like to request the addition of an auto-refresh feature within Smartsheet. I use one worksheet most of the day and I have to manually refresh the worklist several times each hour. It would be great if the auto-refresh feature could trigger anytime someone performed a change but I would settle for an auto-refresh…
-
Conditional Formatting Cell Level
Hi, I need help or guidance in Conditional Formatting at CELL Level not all rows or all columns. For example: if the % is Below 30 its RED, 30 - 80 its Yellow and 80 + is Green. Please see attached the photo for more clarification. Thanks and please help.
-
Help with formula Sum IF i think ?
Hi I Am after some help getting a column of numerals to add only if certain criteria in a drop box are met say if Column A was made up all of the number 2 and Column B i had drop box criteria of "Complete" If i marked Column B "complete" my value would be 2 if i mark 4 Rows in Column B "Complete" my total would be 8 Any…
-
Constraints in predecessors in SmartSheet ?
Hi, I want to create the gantt with schedue as below: Task A Subtask A1 Oct 15 to Oct 19 Subtask A2 Oct 15 to Oct 19 Subtask A3 Oct 22 to Oct 26 Subtask A4 Oct 29 to Nov 2 Predecessors of A3 = Subtask A1 and Subtask A2 Predecessors of A4 = Subtask A1 and Subtask A2 Subtask A3 and Subtask A4 are assigned to the same…
-
Credentialing Tracking Template
Hello, I am looking to set up a credentialing tracking template. I would like to track the credentialing process including but not limited to documents submitted/pending, approvals, etc. I'm curious, does anyone out there have any examples of such templates? Any ideas are much appreciated. Thank you!
-
Sumifs and Children
I am trying to sum the values of child row if three conditions in adjacent columns are met, from another sheet and post it on my main sheet. I reference a parent row and need to sum the children values if they meet the three conditions . Specifically, I use a cell value from the main sheet to find the referenced parent row…
-
Smarsheet data share over mobile no instead of email
Hi everyone At present I am sharing data with others over their email addresses. Is there any method of sharing data over their mobile no? Say user has a what's app installed on their mobile and status update request or report can be shared on mobile?
-
Formula for RYG using % Complete and Finish Date
I am trying to populate my Status field, using RYG formatting (based off the % Complete and Finish Date). I am trying to use an AND/OR and it is not working for me. I can get half way there, but not completely. My Status Definitions: Gray - Not Started Yellow - In Progress Green - Completed Red - At Risk I would like to…