-
I want to add columns with checkbox ticked and return a number
What would be the formula to calculate checkbox ticked and return a number 2 when checked 0 when unchecked? Thanks
-
How do i track progress based on output?
I have a project that involves building fences in a number of locations. Each location has a budgeted lineal distance of fencing, and we will need to track progress of distance completed against budgeted. I can do it in an excel spreadsheet, but would like to have it as part of my smartsheet plan. Am new to smartsheet!…
-
Nested If Formula
Could someone please help me with this IF formula? Much appreciated! =IF([Total Individual Miles]1>350, "Five", IF(Total Individual Miles]1 <= 50, "One", IF(AND([Total Individual Miles]1 >50, [Total Individual Miles]1 <=150), "Two", IF(And([Total Individual Miles]1 >150, [Total Individual Miles]1 <=250, "Three",…
-
Display Year in a 10-Year Cycle
I have a sheet that is used to track where a store is at in a remodel cycle. Currently, I just have a column that takes the later date of two date columns, and adds ten years for an estimated remodel date. I'd like to add another column that displays the year in that 10-year cycle. In this sheet the Future AF column takes…
-
Formula in % Allocation Column?
I am certain this has been asked either currently or in the past, but is the capability to include a formula in the % Allocation column on the product roadmap? Right now, I have a column entitled "% Alloc Calc" next to the "% Allocation" column to calculate the % Allocation for my users. The users must ensure that both…
-
Locking a Sum Formula
Hello - I am wanting to lock a sum formula and am not sure exactly how. Do I need to add additional aspects to the formula beside the "$"? The issue is people are moving items around in their timesheets which adjusts the below formulas and I want to make sure if they do this, the formula will not change. Below are the two…
-
Holding A Column Position in VLOOKUP Formula
Issue = Within my VLOOKUP formula =VLOOKUP([Example]1, {Test}, 16) the column position is 16. If at some point a column is inserted to the left of column 16 in sheet {Test} then my VLOOKUP formula returns incorrect data! Question = Is it possible to get my VLOOKUP formula to hold to the column itself rather than its number…
-
Dual parameter formula to capture last entered date versus last date of column?
Currently have a sheet that allows an end user to utilize a drop down and date column to quickly input their activity related to a row. Once entered, a workflow copies the date and activity to a separate sheet with dates placed into individual columns. Using a MAX/COLLECT reference formula I am able to retrieve the last…
-
Compare dates in the same row but different columns
Hi all, Im looking at counting the number of times two date columns differ within the same row For example Column 1 Column 2 11/2/20 11/2/20 11/4/20 14/11/20 11/3/20 11/3/20 25/5/20 12/6/20 In this data the answer i am looking for is 2 as row 2 and 4 both differ, whereas in row 1 and 3 the dates are the same in both…
-
Difficulties Nesting formula
Hello all, I think I am close to the answer here but struggling to figure out what I need to add to the formula to. Looking for the formula guru's here. Here's what I need this formula to do. I think I am on the right path, hopefully. If "Lab Date Received" row is empty, return "Awaiting FER in Lab" If "Lab Start Date" is…