-
"#invalid column value" Error in Sheet Summary
Hello all, I would like to retrieve the date of "LR1" with the following Index Match function (see field 18). Once I hit enter I receive the error message "#invalid column value". Is something wrong with my formular?: =INDEX(Finish:Finish, MATCH([Field 16]#, [Task Name]:[Task Name], 0)) Many thanks in advance for any help…
-
Today() Function not updating
Has anyone else noticed that the today function is no longer updating consistently when sheets are triggered through either cross sheet references or through an automation that records todays date. I have used these procedures successfully for years but in the recent weeks they have stopped working. I can't go back and…
-
Sheet Summary Question
Hello all, I am trying to do a sheet summary to show the Active Dealers vs Non Active Dealers that are running campaigns. An active dealer will have a monthly total greater than 0. However the Monthly Total Column in the smartsheet is a referencing information from another smartsheet using a Vlookup. I am trying to do a…
-
IF/And/Join/Collect
Hi Smartsheets community, I am trying to create a summary field in a sheet that joins all the text from one column that meets these criteria: has a created date less than 20 days old has a label of "decision" in another column OR a star for priority in another column. I have a sheet used to track RAID entries, and…
-
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?