-
Rounding up the results of an IF formula
I finally figured out how to create an IF formula to get an AVG of Children divide that by a specific number, and enter "N/A" if there was nothing in the children cells. NOW my boss would like to Round the resulting number up to the next dollar value. Sometimes, I think she just likes to test me! LOL Here is the formula I…
-
Aging Items Based on TODAY
Hi, I'm trying to use the TODAY function to work out the age of an item. In Excel I would have a cell with =TODAY(), and do a calculation to subtract the date of the item from this. I have tried using =TODAY(), =TODAY, TODAY, TODAY(), but can't get it to bring back today's date (got #INVALID COLUMN VALUE, #UNPARSEABLE or…
-
$ per month formula
I am trying to put together a formula to track the amount of money we are bringing in per month per project. Not sure if I am doing it right... Any help would be appreicated. Here is what I am coming up with so far - =IF(Phase30)= "Construction", [Estimate $]30/Duration30) I know they duration is only calculated in days -…
-
Rolling Week View in a Report
We have a smartsheet with multiple rows of activities and column headers: "PSA Start" and "PSA End" dates. We want to build 3 reports that shows: (1) PSA End dates due in 0-2 weeks (2) PSA End dates due in 2-4 weeks and (3) due in 4-8+ weeks. Can this be done directly from the report or will I have to create calculations…
-
Count "green balls" within a range
Hello I'm am wanting to count "green balls" within a range. I have used =COUNTIF([Site Attended]11:[Site Attended]26), "green") I'm have the result #unparsable I am a new user so would apprecate the help. Thank you
-
Automate RYG balls when a check box is ticked in one colum only out of three columns
I am trying to create a formula that changes the RYG balls to Green if one box is checked out of three columns. Can anyone help?
-
Trying to Sum Rows of linked cells
I'm new to Smartsheet and struggling with a few things, one in particular is wearing me out. I have several rows of linked cells that pull number values from another Sheet. I'm trying to Sum total these linked cells but the basic Sum formula doesn't seem to recognize these numbers. If I remove the Link the Sum formula…
-
Combining COUNTIF and COUNT(CHILDREN) formulas
Is there a way to create a single count formula that will return the number of rows using two criteria? I need the number of rows with column A = Abby and column F = MONTH(@cell) = 2
-
Could somebody please help with formulas and reports
I have created an action date column on all my spreadsheets, I would like this populated by default with today's date. I would then like a report running in the background letting me know if any lines become overdue i.e. in the past - I plan to display this on a large computer screen visible by all users If anyone can…
-
Formula Help Needed
Hi everyone, Need some help. I'm sure this is a simple formula ... but I'm not Excel (or Smartsheets) savvy enough to figure it out. I have a DATE column, and I have a FLAG column. If the date entered in the DATE column is more than 7 days in the past, I want the FLAG to appear in the flag column. If the DATE entered is…
