-
INDEX and MATCH #invalid value error
Hi! I'm trying to apply a formula we got to work in Excel to our Smartsheet. The goal is to look at a range (Column "1" through Column "Column64") in a single row and find the non-blank cell farthest to the right and return the value from the same column in row 2. (Row 2 was created to replicate the name of the column…
-
System Field: Date/TimeStamp behaviour
Hi all, Have been a fan and avid user of SmartSheet since 2015. Great to see all the continual roll out of new capabilities / functionality. I am currently working on building a triggered notification on SmartSheet -- essentially, if a specific row has not been updated for "x" days, it will fire a notification to a…
-
IF ERROR Formula when trying exclue zeros from average
I am creating a sheet for PM weekly time tracking. The top parent row (blue) is YTD roll up of total hours, as well as a column for average weekly hours (<---- this is my issue but I'll to that shortly). I have a child row (green) for each quarter, and then grandchildren rows (white) for each work week. The child rows also…
-
Populate Start/End Date based on Status change
I use the Card View for quickly creating tasks and tracking their status/state. I'm trying to see if it's possible to take this further and populate the Start Date and End Date fields when the task first enters a specific state. See screenshot attached.
-
Net duration between 2 dates AND times
Hi folks, Ok, this is a tricky one: I'm trying to set something that was requested by many people on this community forum - a NETWORKDAYS that can account for TIME as well. In other words, the amount of working days/hours between to periods (that accounts for. There is this amazing…
-
Need help with date formula
I am trying to create a line chart widget. The chart would display the date an incident or incidents were reported on the X axis. The y axis would display the number of incidents scale. The widget would report the incidents per the last 90 days. Only the date an incident(s) was reported would display. in the chart.…
-
Adding a Title to a COUNTIF formula
I am looking for guidance as I feel like I am missing something really simple. I would like to be able to have a title(label) included in my COUNTIF statement. This is the total count formula I have for the parent row: ="May 2018" + " (" + COUNT(CHILDREN()) + ")" This formula displays in the cell as May 2018 (3) ~~~~~~ I…
-
Sum total number of cartons by date
I have vendors fill out a form every time they have a shipment leaving their building. I want to create a widget on the dashboard for our leaders that show the total number of cartons leaving our vendors each day. (Bar Graph) But first, how do I create a report or formula to sum cartons by date, without me providing the…
-
Formula to count rows in a date range across columns and status
I am getting suck trying to create a =COUNTIF formula from a sheet that has my date column, and several other qualifying status columns.Any advise would be greatly appreciated. Here is where I am at so far and I am getting an #INVALID Data Type error. =COUNTIFS({Sheet1 Range 3}, AND(@cell <= TODAY(), @cell > TODAY(-30),…
-
IF Formula for a sheet
I am trying to get this formula to work correctly. I believe I am close however it is not working correctly. I have attached a screen shot.
