-
Formula Help (does not contain)
Columns "Risk" "Start Date" "Part Status" I want "Risk" to FLAG, if "start date" is TODAY or > and "Part Status" is NOT "shipped" or "in progress" I have the formula below for if start date is today or > =IF(ISDATE([Start Date]4), IF(AND(TODAY() > [Start Date]4), 1)) How can I combine AND if "Part Status" is NOT "shipped"…
-
Task duration
Is it possible to default task duration to hours instead of days. an example, when you enter 5, it reflects that as 5 hours and not 5 days
-
Adding to an Existing Conditional Formula: Date Field
Good Day All: I am trying to add to my existing formula if the date is not populated the harvey ball will remain yellow. If all conditions are met (date submitted, date approved, approved by committee, and Delivery date) then green All help greatly appreciated, Thanks! Existing Formula: =IF([Approved by Committee]2 = 1,…
-
Help with a formula
Greetings, First time posting because I'm not well versed with formulas and I'm hoping that someone smarter than me can offer some guidance. I would like to create a form that assigns a point value to specific activities (e.g. JTA, IDW, SS, TR and so on) identified in different columns and sums the total value of all…
-
Using LOOKUP function on a sheet with a form to add rows
I am having some trouble with using the LOOKUP function on a sheet I have. We want to use a form to create a ad placement name that includes abbreviations of what the user selects. I am finding that the LOOKUP area shifts as new rows are added. I set all my lookup tables at the top of a sheet and then the new rows are…
-
SUMIF - Circular Reference?
Hello all! I'm pretty sure I saw this functionality in one of my Engage sessions, so I'm crossing my fingers that there's a simple fix! I'd like to create a form that would allow individuals to submit project-related expenses for approval. I envision having a list of project numbers at the top of the sheet (see image, with…
-
Database/Contacts
Does smartsheets include a contact list or database feature and if so where do I find it?
-
IF Statement to change cell color automaticlly using dates
Thanks Smart Sheet people for helping out with formulas. No doubt Craig & Andrew and others who have helped are way smarter than me. Its given me a spring board to learn from. Hope someone finds this helpful The formula below is used in conjunction with a column (you need to set up) that will return"Yellow", "Blue", "Red"…
-
Receiving Sign Off / Approval
Fellow Smartsheeters We have a process that necessitates the approval of certain managers at certain gates during the process. What is the most robust way that you have found to ensure approval is received and not just ticked off 'accidentally' i.e. is it possible to assign a column to one person only? any ideas welcome,…
-
Smartsheet slow response
Hi, I would like to know if you are also experiencing that Smartsheet is slow today (Sept. 21, 2017 - GMT+8) Thanks