-
linked cells
I am trying to find an answer prior to initiating a link. My Smart Sheet changes frequently and sometimes daily or hourly. Rows in the Smart Sheet are determining the order in which the projects will be drilled. The schedule will then change and the rows will be reordered to depict a new "drill date". Here is my question.…
-
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},…