-
Find Difference between two Cells that could be Multiselect Dropdowns or Text
I am pretty advanced when it comes to smartsheet and formulas. But this one has me stumped. I am trying to find a way to report on the difference between two text or multiselect cells. Any advice would be much appreciated.
-
Do formulas not work in automation?
I'm trying to make new rows copy the cell in a column under a parent but this doesn't seem to function. Am I missing something? When I run this, it posts '=Parent() which doesn't help me.
-
Remove Formula Error if blank
I am pulling in data from another sheet based on conditions in the sheet. I can't figure out how to hide the formula error if the value from the other sheet is blank. There will be many cells with blank values and a few that have values to pull in and the formula errors overwhelm the sheet. Formula I'm using:…
-
Join Ancestors help
I have a sheet that has a Task Name column which has Parent and Child rows. I have another column "Levels" that tells me the level that each row sits in the hierarchy. My formula does everything except include the data for task names that are at Level 4. I cannot figure out where I am going wrong. Any help is greatly…
-
Metrics Sheet Formula to Calculate Average of Numbers in Column on Main Sheet
Hi, I have a main sheet with the columns seen below. As stated in the notes, I have not accounted for skipping the calculations when a date missing in a row. That's my first request -- correcting the first 3 formulas. Second, I have a metrics sheet where I want to have a formula calculate the average of the numbers in the…
-
Running job to date hours on a project per task code?
How can I have a running total of Job hours to date per task code display on a sheet that shows actual hours vs estimated hours? The problem I am running into is: I have a weekly time sheet that is filled out for the employees on a particular project. The time has to be separated out by Straight Time, Over Time, Double…
-
easier references to other sheets
Hi all, I prefer to use references of the form {sheet_name Range 1} rather than using the "link from cell in other sheet..." because the formula can be copied to another cell where trying to copy the direct-linked cell only copies the value, not the link. If I have a lot of cells all linked to a particular cell in another…
-
Duplicate rank what formula would return the most recent week?
I have a formula to return the date of the 5 highest ranking weeks. Two weeks are both ranking as the 5th week as they both have the same result. Currently it is returning the oldest of the two dates. Is there a way to get the most recent week instead?
-
Add a number of months to a date
Hello I have a field "laste due date" which contains a date, I would like to add to this date a number of months defined in the column "FREQUENCY (month)" so that returns the date incremented in the column "TEST", I have several formulas without success, it's a pity that there is not an equivalent formula in excel with the…
-
Return values from a sheet
Hello, I have a sheet with the following columns: Recordable (yes/no) Date Description This sheet has a list of all injuries . . many line items. In a summary sheet I want to return the "Date" from the most recent line item where "Recordable" = "Yes". On a separate line on the summary sheet, I want to return the…
