-
Formula with checkbox
Hi everyone, I need help for a formula. I have created an ESTIMATE sheet for my projects, but sometimes clients decide that they no longer wan't some items to be included in the estimated. Instead of putting a 0 into my quantities, because I would lose the quantities number and maybe he would change is mind and decided to…
-
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…