-
When a box is checked in source sheet, check box for all records in 2nd sheet where a match is found
Hi Community, Can someone provide a recommendation as to how I can revise the below formula. I'm trying to perform a match using a two match criteria across two sheets. define a condition that when a box is checked in the source sheet and a lookup is performed in sheet #2 he Match function to match on two criteria's…
-
Trouble with join/collect or index/match, with multiple columns and multiple results
Hello, I can't seem to get this right and after too many hours on this, I am escalating it to the formula masters of this great community once again. I am attempting to create a cell that will collect and join all the matched criteria from two different columns with the same criteria. There are multiple matches in both…
-
Novice Smartsheet User! Need help with Matching/Indexing
I need help with a formula! I'll try to explain this as clearly as I can. I need a formula that can tell me the value I circled looking within the range of columns "01. Kick-Off Meeting" to "13. New Contract Start", based on the corresponding "Task Name" column, in this example, "Kick-Off Meeting" if the "Task Status"…
-
#Invalid operation error for summing values
Hello Team! I have a weird case, but let's go straight to the point. I have a simple formula: =SUMIF([F Tracking ID Number]:[F Tracking ID Number], [F Tracking ID Number]@row, [X ASIN Value (CI)]:[X ASIN Value (CI)]) which basically sums values from column X for duplicate values in column F. The formula works fine for…
-
Dynamic view vs reports
Hi! Im having a hard time understanding what the clear differences are between the dynamic view and the reports. I dont like that the people who are shared to edit on a report will by default also be shared to edit on the main source page. Is the dynamic view different? Thanks.
-
emulate the COUNTA function
This discussion was created from comments split from: Odd way to emulate excel formula counta().
-
Linking Parent and Subtasks from a sheet into a report
Hi! I am creating a report of tasks that are in various stages, and some of the tasks have a parent/child relationship. I already tried the 'Helper column' to identify parent tasks. Is there a formula to use to identify child tasks? Also - Is there a formula I could use where instead of just listing the Parent Task Name in…
-
Can i not add times in smartsheet?
HI - I am putting together meeting schedules (or at least trying to) as it would be helpful - then the calendar view would have the date AND time rather than just the title of the primary column. I looked at a Q&A from 2021 and they said to use the JOIN formula in the primary column. I don't really get this. I was hoping I…
-
Formula error
What is wrong with my formula? =SUM(IF({P2F_status_1Q2024 Range 2} = DATE(YEAR(TODAY()), 1, 1), IF({P2F_status_1Q2024 Range 2} = DATE(YEAR(TODAY()), 1, 31), {P2F_status_1Q2024 Range 3} = "billable", 0), 0)) I've also tried this variation, =COUNTIFS({P2F_status_1Q2024 Range 2} >= DATE(YEAR(TODAY()), 1, 1),…
-
Daisy Chain IF(ISBLANK for to meet conditions for PDF Generation
Hello All! Not sure how well I'll explain this... I'm trying to use the PDF generation tool within S.S. and the way its structured/dedicated towards a individual row. I created a template to try and utilize the way it's structured and how I need it to function, however I'm having some road blocks with what the formula…