-
Help using the NOT formula
Hello! I'm trying to write a summary formula to count how many projects have a Resourcing score of 8 or higher and the approval status is not "canceled." This is the current formula I'm attempting: =COUNTIF([PM Resourcing Score]:[PM Resourcing Score], >=8, AND(NOT(CONTAINS("Canceled by Specialist Team", [Approval…
-
Tallying Totals in Summary
=COUNTIF(Created:Created, YEAR(@cell) = 2023) Generates invalid data type Created is a autogenerated date time column when the row is created. example of format - I can get a single cell from the column to return 2023 using the Year() function but when using it in the formula above with @cell it errors. I feel like I am…
-
SUMIF Using criteria from the Sheet Summary
Hi, I have a sheet that captures hours from a vendor. Hours and rework counts (number of times an issue goes into rework) are entered. I need to sum hours and rework counts for the previous month. I have a calculation in the sheet summary the takes the year and month and forms a YYYY-MM field. I am comparing this sheet…
-
Summary of different products from the same column
As a project manager for a locksmith company I use Smartsheet for many things, but would also like to use it as a summary of all products we use for each project. Example: Sheet 1 contains 44 columns that I want a report from. Each column represents a placement for a product. Each of those 44 columns could potentially…
-
Sheet Summary Formula - All Completed Tasks in the last 30 days
Good morning, I am trying to add the total number of closed items within the last 30 days. I have used a lot of the suggested formulas in past posts, but it is still counting ALL completed tasks (72) instead of the tasks completed in the last 30 days (40). I'm not sure if it's because it's a sheet summary and not within…
-
Is there a way to find out if the report is a Sheet Summary or Row Report?
I created a report few days ago and I can't remember if it was sheet summary report or row report. I don't see this listed in the properties of the file. Is there another way I can find out?
-
How can I group a Contact List column from a source sheet in a Report?
I'm currently working on a report and trying to Group and or Summarise a column that is a Contact List from the source sheet, but finding that I can't do this. I want to be able to run a report that groups projects by team member. I've searched Smartsheet Community and Google for answers, and looks like it's not possible.…
-
Enable Cross Sheet References to work with Sheet Summary
I check with Smartsheet to see if this was possible and it is not. I've submitted an enhancement request. Support suggested I post the idea to the Community so folks could "like/vote for" the idea. If by chance someone knows how to do this...reference sheet summary values from another grid, or between sheet summaries on…
-
Calculating Number of Tasks above 50%
I am trying to calculate the number of tasks I have in a sheet, which are currently sitting above 50%... this is for dashboard purposes so we can see how many tasks are in the final-closing out stages etc. My formula is not returning any count whether I try it in sheet summary or a separate sheet.... any clues? Result in…
-
Calculating how long a query has been worked on and how long it remains at particular statues for
Relating to this previous community query, I've got 2x similar queries.. I've posted it in that conversation but wasn't sure if it bumped it up the queue, so thought I'd post a new thread just in case it wasn't. I've used the formula @Paul Newcome provided in his post to tell me how long since the creation date the…