-
Formula to create a round number
Hi - I have this current formula in my summary sheet, what do I need to add to it to create a round number? =([Task Status Complete]# / [Total Tasks]#) * 100 Thanks!
-
VLOOKUP WITH MULTIPLE SHEETS
Hi! I´m trying to use VLOOKUP with IFERROR formula to find an information in more than one sheet, but it´s not working... The formula I´ve been trying: =IFERROR(VLOOKUP([SV / OS]@row;{Base Transações Intervalo 1};6;0),(VLOOKUP([SV / OS]@row;{Base Transações 02 Intervalo 1};6;0))) It always return #UNPARSEABLE I couldn´t…
-
Inserting Unique IDs across multiple sheets
Hello, I am very new to Smartsheets and I'm really struggling with creating unique IDs across multiple sheets. I have 3 separate data sets split across different regions. I can't use regional unique IDs. I need one sequential, unique ID across the 3 datasets (i.e. a national ID). It has been advised that one way to achieve…
-
Is there a formula to count how many times todays date is entered into a sheet?
-
What formula will return the text in the field that is not blank?
The Primary Program field should contain the text from either Primary Program-A field (which is a column formula) or Primary Program-B field (which is also a column formula). I've tried nested IF statements. IF([Primary Program-A]@row, "", [Primary Program-B]@row) works but when switched, IF([Primary Program-B]@row, "",…
-
Need cell to populate with fixed percentage amount of previous cell
Hi all, I am having trouble doing something so simple, I think I'm making it harder for myself. I have two columns, "Hard Job Cost" and "Commission", as I get a percent of the job as commission. So, if the "Hard Job Cost" is $30,000, my commission is 1.5%. I can't seem to figure out how the "Commission" column shows the…
-
How to Calculate Percent Complete in Sheet Summary
My sheet is used as a task checklist for projects. It currently has a 'Status' column for each Child task with 4 dropdowns (Not Started, In Process, Complete, N/A). I am trying to create a percentage in Sheet Summary that calculates the number of fields that are marked 'Complete' in the selected cells. Pulled this formula…
-
Trying to flag an item within a date range.
I am using the Asset Management template set and need to have the dashboard update when an item is due within 7 days of the assigned due date. I tried the below formula: =COUNTIF({Sheet - Asset Tracker Range 2}, TODAY() + 7) Asset Tracker Range 2 is the assigned due date. This is giving me everything due exactly 7 days…
-
How do I count the reason for the consult, AND the year it took place?
I tried to amend this formula to report by year. Below is the formula I tried, which didn't work. The reasons are part of a drop down on another sheet. The consult date is on the same sheet, but the full date is in the cell, 10/12/2017, 11/1/2017, etc. My current formula in the TOTALS to DATE is: =COUNTIF({Reason for…
-
Return value if date falls within range
I have researched others' questions on this and I feel this should be right, but it's not. I'm trying to return the generation based on DOB: '=IF(DOB@row <= DATE(1943,12,31), "Traditionalists", IF(AND(DOB@row >= DATE(1944, 1, 1), DOB@row <= DATE(1959,12,31)), "Baby Boomers", IF(AND(DOB@row >= DATE(1960, 1, 1), DOB@row <=…