-
CountIf And
I am looking to count how many audit types, "DD", did my auditor "Brian" do. I am referencing and different sheet. =COUNTIF({MB Intake Audits - 2024 Type of Audit}, "DD", AND({MB Intake Audits - 2024 Auditor Name}, "Brian"))
-
SUMIF Formula
Hi - I am having a problem with my SUMIF formula when it contains the 'Scheduled' column. My formula works if I remove the "Scheduled' column, but when I add that column, I get the message '#Invalid Data Type'. I need to have it included. I attached a screenshot for more information. Any help would be appreciated. Thank…
-
How to make Value be based on a cell for Automations?
Hello, I have a automation where i need it to trigger when a cell matches another cell value. So I have a column with an requestor email that is inputted by a form that Person A would fill out. I also have a modified by column to show who was the last person/automation to modify it. I also have a text field for additional…
-
CountIF issue
=COUNTIF({CBG Cold Spring, MN Items List Range 2}, {CBG Cold Spring, MN Items List Range 1}, >DATE(2024, 1, 1)) Hello i am trying to find non blank in a column based on the criteria that is after 1/1/2024 and this is not working. It says incorrect argument set.
-
Duration and Date Dependencies - Reference Cell in Same Sheet
Hi, Very novice user here. I am using Dependencies and am trying to find a way to make the Duration and Start/Complete Dates reference another cell within the same sheet. Screenshot attached. I'm trying to have the information in the Project Summary cells pulled into highlighted durations/dates so that it doesn't have to…
-
Check In/Out inventory log
Hello, I am hoping someone has an idea for a solution to my problem. I have an inventory that keeps track of giveaways. I created a second sheet with a form to fill out how many of each giveaway I pack for each event. I count the giveaways that come back after the event, and I need a way for this to reflect the number…
-
Allow formulas to function in reports
Currently formulas do not update while in a report. If a value changes, you must refresh the report or window to see the updated formula. This creates a lot of confusion since we use reports to gather updates, which results in me being told "your smartsheet is broken" because the formula columns do not update.
-
Auto Sequence by Date?
Hello! I am creating a sheet that will house projects that need to be prioritized by date. Although I can sort them myself and number them, is there a way to auto number a column based on the date column? In other words, if I have 10 projects with 10 dates, can Smartsheet apply a value in my "Order" column based on the…
-
Using CountIFs with cross reference and multiple criteria
Hello! I am looking for some assistance on a formula. I have a Master Sheet and a Helper Sheet. I am trying to calculate the number of specific events associated with a person within a date range utilizing cross-sheet reference. I have tried multiple formulas, but not having any luck =COUNTIFS({Sample Master Type}, "New…
-
INDEX/COLLECT with Partial Text Match
Hi - I'm trying to use an Index/Collect formula to bring back information based upon two text variables that could be included in my search range. Below is the formula as I have written it and I get and Invalid Column Value error when it runs. The columns that I am pulling information from are restricted dropdown columns…