-
Automatic Levels?
I'm trying to include a parent row (acting as a header) in a report if a child meets certain criteria. For example, if a child task is 'at risk' (flag is set), it will show up in the report. However, I have no idea who the parent is. I only want to include the parents of the problem children — I don't want to see every…
-
How do I get my excel formulas to work in smartsheet. I am getting #blocked & #unparseable
-
Recording the difference between two date cells associated with a value on another cell
Hello All, I have two locations where vehicles are going and spending time being worked on. I want to record the days each vehicle spends at each location. I cant seem to be able to count the difference between dates based on location. Thanks
-
Programatically changing date ranges per column
Dear all, I created a capacity overview sheet that sums the hourly allocation of co-workers between two dates, i.e. between today() and today(7), so one week from now. I would now like to extend that functionality to between today(8) and today(14), today(15) and today(21), and so on. Is there a smart way to do this…
-
Multiple lookups query
Hi, I've a sheet with various user names and 5 columns and trying to get the lookup to report on a user name and count up total of same instance in each of the columns -this can be 0-5 per row. In essence below is what I am trying to get to: If user name = "Joe Bloggs" and column 1 = "abc" OR column 2="abc" OR column…
-
Is anyone getting the wrong week number when using Weeknumber formula?
I am referencing the date of each entry and using the date number to trend data. The formula is =WEEKNUMBER([Inspection Date]@row), where Inspection Date is a date field. For today's date, 4/28/2021, it is returning week 17 - however, in Excel, it returns week 18. To further test, I augmented the weeknumber formula to,…
-
Formula help
I have some columns with formulas that pull in information (if information is available). If the information is not available (filled in), the column puts "#Invalid Value" in that column. Is there a helper row formula I could use to say if the previous column has "#Invalid Value" then enter a space (which I can do) but I…
-
Need Formula: Per Facility per Model #, how much +/- from par level.
I need to add a column formula within the Stock Inventory Sheet, in the Qty. Above/Below Par column, that calculates per Facility per Model #, take the quantity from Order Type Stock Order Row – Facility Specific Part(s), how much above or below are we from the Par Level? So something along these lines: Per Facility, Per…
-
Mimic name manager (excel functionality) and logic in Forms
I have a sheet with a column that contains a column formula to index, collect a response from a "metric" sheet. I would like to include this column as a hidden field in a form so that I can apply conditional logic to then display the corresponding column and dropdown list for the user to select. This is a workaround…
-
is it Possible to build a Date using Strings(Text Columns)
For example, let's say I have a text Column Called "Day" and another one called "Month" I was trying to accomplish something like this: =DATE(YEAR(TODAY()), MONTH(DATE(YEAR(TODAY()), Day@row + Month@row)), DAY(DATE(YEAR(TODAY()), Day@row + Month@row))) Context: * I'm trying to create a Birthday Reminder, so I want to be…