-
Help with countifs formula
I am a bit new to complex formulas so hoping someone can help. I am trying to add a column on one sheet, that falls into two basic categories on the same sheet. The formula I am using is as follows =COUNTIFS({MM Non Prod Issue Tracking System}, [Distinct System]@row, {MM Non Prod Issue Tracking Days Old INT}, <=30, =[down…
-
Sumifs question
Failry new to Smartsheet, I can do this so easily in Excel, but not in Smartsheet. I'm basically trying to add an amount requested based on whether or not the request was approved. The approval is a dropdown menu with only 3 text status - Submitted, Declined, Approved. I want to add the Request Amount column and only the…
-
Project Approval Received / Master Project Sheet Populated
I'm trying to setup an intake process where a new project is submitted through a form and appears within a project intake sheet for review/approval/denial. If approved, I'd like certain, if not all, column values for new projects to be copied over to a master sheet, which includes additional columns for project charter and…
-
#INVALID DATA TYPE
Hi, I am using the following formula that calculates the # of days between a date field and TODAY(). I have an issue if there is no date in the field and giving an #Invalid Data Type error. I would like it to either be blank or if possible to say "Please provide a Date" Formula =NETWORKDAYS([Lease Stage Date Changed]1,…
-
Material Tracking
Please help haha It is difficult to put into words exactly what I am trying to accomplish, but I'll do my best. Please ask questions if I'm not being clear enough. Example: I have a material column for material that is being delivered to a job site (Sheet name is Delivery Tracker). Each cell in the column is an individual…
-
How do I extract the values from a multi-select dropdown?
I am trying to count values from multi-select dropdown. We asked how many check-ins people would like to have: 1/year, 2x/year, 4x/year, etc. (a total of 6 options). When I did my counts, rows with more than one selection weren't counted. For instance, someone chose 2x/year and 4x/year. However, when I use the formula…
-
Formula referencing data is returning off by 1 week
Hey there, I'm currently using the below formula to pull in and report the availability of our consultants on a per week basis. The formula sits in a Smartsheet that references another Smartsheet where the data is in two columns from a start date to an end date every week that Consultant is booked. The Smartsheet utilizing…
-
Struggling with SUMIFS
I am trying to use SUMIFS to total a column from another sheet ({Recap Total Range 3}) with the following 3 criteria - matches unit #, and between two dates, I continue to get either impearsable or incorrect argument and hoping for some help. =SUMIFS({Recap Total Range 3}, {Recap Total Range 2}, >=$[Start Date]$1, {Recap…
-
Automatic Move Row and External Sheet References
I am having issues with the Automatic move row function and external sheet references. It doesnt seem that the automation will trigger if the formula needs to look up a value from a different sheet. Proofing is not turn on for this sheet. See screenshot for the formula Automation: If cell= "a number", then move to another…
-
Automatically enter category into cell
Sorry, I do not know how to say this. I would like to see if there is a way to automatically enter the category name into a cell. (see image) I've manually put the category in the highlighted box but I'd like to see if there is a faster way? Thank you
