-
COUNTIFS formula for year + stage columns
Hello, Please could someone help me with a formula to calculate all projects that have a the year 2021 in the auto created date + where the stage column = Complete Thank you!
-
Unparseable error
I created a formula, for tracking time, and as the owner, it works really well. But when I share the sheet, no-one else is able to use this. The error message comes back as unparseable. This is the code. fx=SUM(((TIME([Time Out]20, 0, 2) - TIME([Time In]20, 0, 2)) - [Non Billable Breaks/Mtgs.. ETC]20) * 24). thoughts?
-
Index/Match works on all rows except a couple
Hello, I have a strange issue where my INDEX/MATCH formula seems to work on all rows except, for example, this one below. This is a listing of requests for a client. I've hidden certain columns for privacy, but the hidden columns are not used at all in the formula. Every request has a unique ID (primary column). There are…
-
COUNTIFS for whole Sheet
Hey, This is probably an easy fix but I am having no luck. I want to count if anywhere on a sheet has a "4" in a cell. I also want this to separate the counts by "ITCMW", "ITCT" & "METC" My current formula is: =COUNTIFS([Pre Trip Completed]:[Doors/Gates], HAS(@cell, "4")) I need to include System:System, "ITCMW" in this…
-
Help with automating future versions of Smartsheet
Hi, Looking for some help in automating versions of smart sheet by manipulating existing data source. For instance here new Dec version needs to be created by automating & editing the Nov source data.
-
How do I filter a report so that it shows only 1) a parent row, along with 2) the last child row
I have a Master Project list. I'd like to run a report on it that shows: Only the projects whose status is "Active". Easy enough to accomplish with a filter. But I would also like to reduce it to show: Only the parent row of "Active" projects --- along with... the last child row that has any data in it Is this possible? It…
-
Gnatt Chart Label - position (can it be in front of bar)
Hello The Gantt chart works well and the lable is also good. But is it possible to chnage the postion of label to front of gantt bar istaead of the end of the bar? Sometime the task duration is long and it is hard to see the lable without scrolling to the end of bar. Either in front of bar or below bar (front) will be…
-
Record a cell on the first of the month
I'm looking to record a cell on the first of the month for a report at the beginning of next month. All of my data can change Dailey based on what was done throughout the month or year. As you can see the Scheduled E for 2022 has the current running values. The way I have it now by the end of the month when the report will…
-
Conditional formatting an entire sheet?
I'm looking to set up a workplace roster on Smartsheet, to cover the 50-odd employees in our workshop. each employee has their own column date tracks row by row each cell tracks daily rostered hours for each employee I already have something of this sort set up, but I want to develop it an extra step or two so it will be…
-
Networkdays with If
I am trying to run the networkdays formula based off a certain status. So what I am trying to accomplish is if the position status shows filled, how long did it take to fill? Here is the formula I am trying and I get the Unparseable error. =IF([Position Status]@row='Filled',NETWORKDAYS([Submitted to HM]@row, [Overall…