Some of our projects go on for a very long time. Each group has their own list of projects. We add status notes in the Comments. The status notes can get very long and cumbersome; however, they are very beneficial for the project history. My boss has asked to remove the status notes except for the

Hi I'm trying to fill out the hours with Index/Match. It works with some but not with other. Here is the formula I'm using

=INDEX({Week 19}, MATCH(Matter2, {Matter})  (Image 1)

Image 2 - Were data is pulling from

On some it works however on other it defaults to the first one. In the 3rd Image I use

I was counting for current month. However, I keep getting invalid data type.

=COUNTIF({Month}, MONTH(@cell) =

I'm looking to find the the sumif of current week for a specific matter. However the matter is only listed in the parent row

=SUMIFS({Test Hours}, {Week Number}, @cell = (WEEKNUMBER(TODAY())), {Matter}, =PARENT({Matter}@row)

I keep getting an error in the

Hi, all!

Our office is new to the SmartSheet community.  I am having some trouble creating a formula for a sheet.  I have the following columns:

• "Initial Contact" - formatted as a date
• "30 Days Since Contact" - formatted as a green traffic light
• "60 Days Since Contact" - formatted as a yellow

I may have a basic misunderstanding & need some clarification.

I have a task #3 (the Effective Date) of a contract.  Further down the project I have another task....

#20 - Purchaser obtains an updated Survey & Title Commitment.  Task #20 can begin on the Effective Date (task #3).

Further down the

Hi,

I can figure out the sumif for the current week but I would like to add another criteria. I keep getting an error could someone help assist

=SUMIFS({Week Number}, @cell = (WEEKNUMBER(TODAY())), {Capacity}, {Work Type}, @cell= "Budget")

I have a formula that will give me the current week capacity:

=SUMIF({Week Number}, @cell = (WEEKNUMBER(TODAY())), {Capacity}).

However I'm not sure of the formula to capacity for the next week or the past week capacity

=SUMIF({Week Number}, @cell = (WEEKNUMBER(TODAY()) +7), {Capacity}).

I

Hi, I think the graphs implemented last year were an excellent and needed set of features.  I still however have to use PowerBI for some of our charts.  This is problematic.  Can we get Radar Charts into the Graph

I'm looking to create a total data sheet that gives me the total spreadsheet for the current week, next week and previous week, from data from another worksheet. The problem that I have is that the dates are the column names, does anyone have any suggestions on how to accomplish this. Currently I