-
Counting days of ticket open but starting at 0?
I asked this question before and got a solution but now it is counting starting at 1 instead of 0. this is the formula used =IF([Date Closed]@row = "", NETWORKDAYS([Date Opened]@row, TODAY(0)), NETWORKDAYS([Date Opened]@row, [Date Closed]@row)) I tired using (today -1) but then it starts at -2. The date closed is an…
-
Calculating formula for total pay for hours worked?
Hi, I'm wanting to create a timesheet where 1hr = (ex.) £10, and hours can be input by an individual and the smartsheet will work out how much they are owed. First calculation to be row, 5hrs = £50, second calculation to be the total of the column 5x £50 = £250. Is there a way to assign a value to a number e.g. 1 = 10, so…
-
Lookup and Return a a the Unique Values
I have requirement to review the TYPE and return the Food value in unique list The outcome should like this written a formula like this like this =IFERROR(INDEX({Range of "Type"}, MATCH($[Food], {Range of Food}, 0)), "No Match") the outcome is coming like this. Only the 1st row is appearing and not the others
-
INDEX MATCH Formula with Cross Sheet References
Hello, I am trying to write an INDEX MATCH formula that will return a due date on my metric sheet while referencing a much larger projects sheet. Currently, my metric sheet has two columns: "Project Description" and "Initial Documentation / Broad Scope Due Date" Both of my project descriptions are identical - one is a cell…
-
How to use automation to copy only certain rows to another sheet?
I have large rows of dataset in a sheet. I am looking for a solution that can copy specific rows to another sheet based on certain criteria. I used the automation template for copying rows, however, on fulfilling the condition specified, the automation all rows in the primary sheet to the secondary sheet. Is there a way I…
-
Merged: Hyperlink transfer with VLOOKUP or INDEX(COLLECT)
This discussion has been merged.
-
Subtracting data from more then 2 columns
Hello, I have been trying to subtract numerical data from three different columns, and I have tried =[Submitted HRs]@row-[Lunch Time]@row-[Contracted HRs]@row and get invalid operation I tried using parathesis =([Submitted HRs]@row - [Lunch Time]@row) - [Contracted HRs]@row and get an invalid operation I have also tried…
-
change status based on previous row
Is there a way to have a formula change the status column when the row above it changes. For example when the status in Row 1, changes to "Complete" the status in row 2 will change to "Ready to Start" I know I can't put a formula in the drop down so I imagine some sort of helper column would be needed. or could this be…
-
Join+Collect by rows
Hello, I am trying to create a smartsheet formula to aggregate summery information from an amendment sheet onto a master sheet. However, when I attempted to use join() +collect() my cell returned all date finalized collected then all #s collected and then all types collected. I want to return data in ROWS not COLUMNS. In…
-
Summary Fields for Dashboard based on dropdown values
Hi All, I have a rewuirement and, although I have a solution, it is very manual. I was wondering if there was a better andmore efficient way of doing what I needed. It is a question of reverse engineering in that my requirement starts with the end product a dashboard. On this dashboard I wish to show, in graph format, how…