Formulas
Discussion List
-
Formula issueIn Formulas and FunctionsHi Can someone help me to write these five formula in a single formula to get the schedule health. IF([email protected] = "Not Started", "Gray") IF([email protected] = "On Hold", "Yellow") IF([email protected] = "…Answered - Pending Review 1 view 3 comments 0 points Most recent by Toufong Vang Formulas and Functions
-
Formula not workingIn Formulas and FunctionsHi , Can anyone help me with this formula issue:- I have 4 symbol color- Not Started- Gray Not Applicable- No color On Hold -Yellow Complete- Green Act1 greater than Act2 and Status is equal to In Progress - Red else Green =IF( Status…Answered - Pending Review 11 views 1 comment 0 points Most recent by Toufong Vang Formulas and Functions
-
Counting dates by week, months and year formulaIn Formulas and FunctionsHi, I have a SmartSheet which logs enquiries. I need to create KPI report to measure the number on enquiries that are logged that day, this week, this month, last month, and year. Also a monthly running today for example Jan = 40, Feb = 5…
-
How remove a character ">" in order to SUM values in one column if they meet a criteria.In Formulas and FunctionsI need to be able to get the results using a formula. (I can't use a helper column, or the find and replace to remove ">". Logic needed: This formula should substitute the greater-than sign with nothing and convert those to nu…Answered - Pending Review 12 views 3 comments 0 points Most recent by Mark Cronk Formulas and Functions
-
if formulaIn Formulas and FunctionsHi I was wondering if someone could assist. I'm trying to have a box check if the criteria on two sheets are the same. Example would: I have a column called Submission Number on one sheet and I have another sheet with a column with subm…Answered - Pending Review 11 views 1 comment 0 points Most recent by Bassam Khalil Formulas and Functions
-
Return task name associated with a future dateIn Formulas and FunctionsI have a project with linked tasks. I can get the start date of the next task using the following formula: =MIN(COLLECT(Start2:Start6, Start2:Start6, >TODAY())) How can I return the task name associated with this upcoming task? In th…
-
Formula for Actual duration excluding duplicationIn Formulas and FunctionsHi Community, I am trying to calculate the actual duration starting from a list of Start and End dates. What I am trying to achieve is to exclude duration overlaps in order to get the actual effort days only, but including not contiguous…
-
Date Comparison in Functions is Not WorkingIn Using SmartsheetThe following formula returns a value of zero (0): =COUNTIFS({DATE ONLY}, [email protected], {Shift}, ="1st", {Degreaser Check Passed?}, <>"BLANK") Here is the sheet that is being referenced: DATE : Contains only dates o…
-
Return status of cell (blank vs. full) at today's date.In Formulas and FunctionsHello! I am trying to use a function that will tell me whether a cell is vacant or full at today's date. We are trying to create a desk booking system for our office, so the end-goal would be to have a vacant/occupied indicator on a SS da…
-
How to calculate tenure (years of service) between 2 dates?In Using SmartsheetHello, I am trying to get a date on the Years of service column. In excel you just minus today's date-start date and it will give you a result with smart sheets I can't figure out how to do it. Can somebody help me?
