-
days since last comment
Hello, I would like to create a column that tells me how many days since the last comment. Is there a way to do this?
-
Dashboard formulas - Need to count if a person is included in Owner Column and the task is not close
Trying to calculate the number of tasks by person that are not closed. I currently have: =COUNTIFS({Tracker Range 6}, ="Andy", {Tracker Range 2}, <>"CLOSED") Where the Range 6 is the Owner column and Range 2 is the Status Column (Open, Closed, Hold). I am getting responses, but I think it is only counting where the owner…
-
Countifs with reference sheet and current sheet criteria
I am trying to create a count if depending on both columns from my main sheet (utilizing reference sheets) and columns in my current sheet. I tried the following formula but I get an incorrect argument set error. The 2 OPS Tracking Range columns are checkboxes that I want to only count if they are not checked.…
-
Determine # days from 1 date range to today
Looking to assign a % complete to a project based on days from open to estimated close. Have a column showing total network days from these dates and now want to either nest a function to subtract the overall days from the current days (open to estimated close minus open to today). I am new to Smartsheet so am having a…
-
Counting Harvey balls by row owner
One column of my sheet is a 5-symbol Harvey ball (Sunny, Partly Sunny, Cloudy, Rainy, Stormy) to show the relative health of a row. Another column is a Contact List type that shows to whom a row is assigned. I would like to extract the total number of non-Sunny rows per team member. What I have done is to add two columns.…
-
Linking Sheets
Due to the 200 column limit in a sheet, I have had to split my data into multiple sheets, using the project name as the Primary Column for each sheet. I know how to links cells and use IF formula to pull the Project Name column data, but I cannot for the life of me figure out how to automate it, where if I add a project…
-
Multiple IF statements referencing another sheet
Hello, I'm trying to create a formula that references data in another sheet and looks at multiple criteria from two columns: 1. the name of the person and 2. the entry falls between two dates, then I want to return the value from that sheet. Wondering if I need and IF(AND( formula? Here's what I have so far: =IF({Auditor},…
-
SUMIFS and date
Hi All, I am trying to reproduce this excel formula in smartsheet =SUMIFS(Sheet2!C:C,Sheet2!A:A,"<="&A2,Sheet2!B:B,">="&A2) I am trying to get a result equivalent to Column B in sheet 1 (see attached file) based on criteria in sheet 1 on column A from the data in sheet 2. My formula in smartsheet is =SUMIFS({Sheet2 Column…
-
Capture Timestamps Before They Change
Is there a way to save a date that something occurs? We have rows that get changed constantly, and the status balls change from Green to Red to Yellow to Gray. Any way we can capture the date that a row's status ball changes to Red, even if it later changes to other colors? Thank you!
-
IF / OR Formula help (#Invalid Column Value)
Hi everyone, I am trying to figure out a formula, that will show the following result: * If the completion date is before the due date, the green circle appears; or * If the completion date is after the due date, the yellow circle appears; or * If the completion date is blank, the red circle appears. The formula I have is…
