-
VLOOKUP Formula
Hi Smartsheet community! This may seem like a simple question but I cannot figure out this formula for the life of me. I am trying to do a basic VLOOKUP formula. On sheet #1 I will have a column that lists employee alias's and a column that will VLOOOKUP that same alias's level from sheet #2. On sheet #2 it will be a list…
-
progress percentage cell not accepting formulas
Hi, I have a column to display the percentage of completion for each row, I would like to use something like the below formula in this cell, to automatically update this value, however, Smartsheet is not interpreting this as a formula, instead, is putting a ' sign before the = sign '=IF((Status@row = "Done"), [%…
-
Count status of tasks between 2 dates
Hey there! I'm trying to find a way to reference data from one sheet into another, with a formula that will count some metrics to display on my dashboard. I've managed to do it for counting task status for the whole project but am struggling to figure out the formula to narrow down specific tasks between dates. Previous…
-
Sheet Summary equation
I am trying to create an equation in a Sheet Summary field that counts all items that have not passed approval. This would involve counting all items in the Status field that are Not Started, In Progress, Failed, or On Hold. I have tried multiple variations of the CountIf and CountIfs statements, but everything is…
-
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…