Mike Wilday’s Profile

Community member since February 2017

points
7709
Company
Los Angeles Pacific University
Department
IT & Operations
About Me
Skilled with SmartSheets reporting, formulas, cell-linking, sheet setup, etc. Email: [email protected]

4

I am using the following formula (gained from a previous community entry, thanks guys) =IFERROR(NETDAYS([Construction quote date]@row, TODAY()), 0)

it is calculating the number days between a quote date column and today's date.

however I want to fix the number of days when the actual close date is

3

Hi,

I want to sum a column based on multiple criteria from one column. I have accomplished this in the following way:

=SUMIF({Stage}, "Proposed", {Volume}) + SUMIF({Stage}, "Sold", {Volume})

Is this the best way to do this or is there a cleaner way to accomplish the same thing.