-
OFFSET Function
Hi, I need to calculate the sum across a number of columns that will change every month (mon columns are set from January to December for each year). This would easily be done in Excel via an OFFSET function and I can't find what the equivalent would be in Smartsheet. What I am trying to get at is this:…
-
Trying to Use Join and Collect in a function, Says Calculating, but blank result
I am having an issue getting this formula to work for me. This is based off a previous question asked and answered but I can not get it to work for me. Sheet "1.Master" where I want the consolidated information to go contains [Site No] column (unique identifier/primary column) and a column called "Zoning" among 50 some…
-
Show date based on other dates
I'm trying to get one cell to show the actual end date of a TSA. We have the initial date agreed, the early term date and the extension. Only 2 of these cells should ever be populated as it can't be extended and ended early. If the early term date and extension date are blank then I want to show the initial date agreed but…
-
How to use SUMIF to cross reference two sheets
I am working on a sheet, Electrical Inventory Modification, that collects part numbers and quantities based on a form that employees fill out. I have another sheet, Electrical Inventory List, that already has a list of parts and quantities. I want the Electrical Inventory Modification sheet and the Electrical Inventory…
-
Copy and paste files
Can I recreate another folder with the same files with all the links? I created a set of files and populated it so I can test my formulas and generate dashboard. Now that its "fully" tested. I want to use the same set of sheets and dashboard for users with "blank" cells for users to start populating. But I want to keep the…
-
Help with a formula to sum the hours by month by project
Hi all - I need some help building a formula that will show the sum of hours by month (see attached summary sheet - columns Jan 2021 Hours / Feb 2021 Hours) by project. The data that it needs to sum is on the Time Tracking Entry sheet. The unique identifier on both sheets is the "ID". Thanks in advance for any help you can…
-
COUNTIFS Reference Another Sheet, Category Type and Date Range
Ask for help: I have a master sheet with all of the data that I am trying to pull from. In this sheet, I have already achieved the desired outcome in the 'Sheet Summary'. Explanation Summary: Count issues by categories types within Q1 Formula in 'Sheet Summary': =COUNTIFS([Category Type]:[Category Type], "HVAC", [Date…
-
Countif todays date and by someone
I want to count how many times someone completes a form today I was able to count if yesterdays date with: =COUNTIFS({Store}, $Name6, {Created}, TODAY() - 1) but can't find a way to calculate todays entries
-
Checkbox if another field contains text, but don't check if it contains other text
I'm trying to check a box if it contains one of several text strings. But if it contains another subset of text strings, I want the box to NOT be checked. I got it working for the finding text portion, but I can't figure out how to make it remain unchecked if the other text strings are found. Here is the first string that…
-
SUMIFs Contains returning unpareseable
Here is my formula that is not working, any ideas what's wrong? The Audience column has multiple options, but I want to track each individually. =SUMIF(Audience:Audience, CONTAINS("DBM",@cell) [Time Commitment]:[Time Commitment])