-
Check Box and Conditional Formatting
Hello, was hoping to get some advice ... i have a long drawn out conditional formatting expression that will turn a row a certain color once it is all met .. at that point i want a box to automatically be checked to indicate that the expression has been meet and something is ready to send .. i was looking into if formulas…
-
Best way to report a top of funnel of requests metric
Hello, We are using Smartsheet as an intake form of new projects. What I need to do is do a COUNT of all the projects that came in for this week and also by product type, and region request. However, the only way I can think of doing this is to pull a report that looks at the created date and 7 days back, but I know you…
-
Formula does not always recognize "" for blanks?
I have an odd one that hopefully someone can shed light on as i am going a bit crazy :) I finally figured out a formula i have been working on for few days ... strangest thing it seems to have been the quotes that i was using ??.... I used the quotes (directly to the left of the enter key with shift ) as a blank and i…
-
COUNTIF FORMULA ERROR
Hi all, I'm fairly new to Smarthsheet and have run into a simple COUNTIF formula error. I want to simply sum all cells in a column that contain the text "*C-000*". My formula is below and I don't show an error in the formula but I also have zero results where I should be showing a sum total of at least 26.…
-
IFS Formula with Past Due, Not Completed
Hi, Hoping I can get some assistance on a formula for to give me a count if the following is met: Count the # where: Type column is "Task" or "Sub-Task", Task Status column is "Not Started" or "In Progress" and End Date column is Today or In the Past I would like to not add any additional columns. Thanks!
-
=NETDAYS([Expected Finish Launch Date]48, [Planned Finish Launch Date]48) returns 1 when date is the
Using formula as follows should return with a 0 if the dates are the same. Why is it returning a 1 instead? A similar formula if used in Excel will return a 0, so I would assume Smartsheets would do the same. Am I missing something in the formula? Thanks, Lawrence
-
Hours Calculation
Is there any way to calculate the difference between two differente times, like: Column 01 ==> StartTime: 11:00 Column 02 ==> EndTime: 12:45 Column 03 ==> Hours: 1,75 Thank you
-
#REF in Predecessors
What do these errors mean in my Predecessor columns and the Edit Predecessor set-up window? I can't figure out what to do with them. I searched the Help Center and they say that #REF means "The formula references a cell which does not exist, possibly due to a row/column deletion." but this is not in a formula so I can't…
-
Accounts Receivable formulas for SmartSheet
Good morning, I am seeking formulas to help setup my accounts receivables SmartSheet based on the Status Stage from my project management sheet. Is there a formula for extracting from my "Invoiced" stage the cell history date from that cell. This is the date the status of that cell turned to "Invoiced". Then I will like a…
-
Using COUNTIF or SUMIF to evaluate a date range
Hi, so I have a ColumnA that has random dates for the current year 2017. The column is formatted as a "Date" style column. My goal is to sum each date in this ColumnA by Month: Example: So to the right of each date, I want the sum of all dates that are in "January" that are in Column A. Thanks
