-
Calculating work hours %
I feel like this should be very simple but my math just isn't checking out. I have a duration column tracking how many weeks per task the work will take. I also have a "work hours" task that is tracking how many actual hours the work will take over that given duration. I'm trying to make it so my "Allocation" column…
-
Preserving Approval Date
I heard in an ENGAGE 2018 video on alerts is that you can set an alert to request approval based on the values of one of the cells in the row. You can choose a column with drop-down properties to indicate that the alert was Submitted, Declined or Approved. Someone at the session asked if there is a way to know the date of…
-
Average with multiple columns
I have a sheet that collects information about quality control scores. I have a column "Total Points" that I am looking to average; however, I am trying to use two different columns to base the average off of "Region" and "Quarter" so basically if the region= Southeast and the quarter =Q1 I want to get an average of Total…
-
Formatting A Sheet
Hi all! I am back again with another Smartsheet question! This time I'm not certain if what I'm asking for is even possible. I was wondering if it would be possible to format 3 columns to make them smaller and more digestible. At the moment, I have a sheet that displays dates tasks have been completed, the week of that…
-
Creating a count using COUNTIF across multiple columns
Hi, i would like to count the number of yes's in a column with a corresponding service line in a separate services column my first column has three drop down options yes/no/NA and i would like to be able to count each one So for example: M&E yes = 37 M&E No = 12 M&E NA = 2
-
Taking Weekly Average Every Friday.
Hi all! I have a spreadsheet, on this sheet I have some values I would like the average of as well as dates assigned to these values. Taking the average is not the only thing I need to do, I need to take the average of these values, grouped by week, from Friday to Thursday. Meaning I have to find a way to group the values…
-
COUNTIFS NOT ISBLANK from another sheet
Hello, I am trying to create a =COUNTIFS function, I know the it works up to the NOT ISBLANK part, I don't think I am off by much, but am not sure what I have wrong, can this please be looked at? Thank you so much! =COUNTIFS({Project}, $Project@row, {Status}, Completed$1, {Metrics & Production Dashboard Build End Date},…
-
Issue with INDEX MATCH
Hello Everyone, I have an index match formula that only works for the first row in my sheet and I have no idea why. The first row brings in the right value, all the other rows come back with #NO MATCH. There is data to be pulled back for the other rows and a VLOOKUP works. What am I missing? Thanks!!
-
Issue with calculating days between two dates - returns #INVALID OPERATION
Hi All, I have a column Start Date - that is formatted as a DATE column type Then I have a TENURE column - that is formatted as a TEXT/NUMBER column type In the TENURE column I am using the formula; =TODAY() - [Start Date]@row This formula used to work fine for me - but more recently when I log into the sheet it now…
-
How to include a cell value name in my automation list
To setup automation, the trigger part works perfectly fine. However, the response is to change the cell value, but the cell name doesn't appear in any of the options.