Nat
Nat
Reactions
Discussions
- Hi all, Is there something wrong with this formula? I just want to count how many rows fall in each financial year, and I can't tell what I've done wrong. =COUNTIF ([Date of Request]:[Date of Request]…
- Hi Smartsheeters, I would like to group my milestone report by workstream, so I added a "join ancestors" column. I also have a "count ancestors" column that can be used. My current report is a nightma…
- My past due report was showing the naked tasks without context, so I wanted to add the parent. I added a helper column with '=(PARENT(Tasks@row)) and grouped the report by that column. That works for …
- Happy new year Smartsheet crew! I'm returning the quarter of my end date using this formula: =IF(MONTH([End Date]@row) <= 3, "Q4", IF(MONTH([End Date]@row) <= 6, "Q1", IF(MONTH([End Date]@row) <= 9, "…
- I just realised the top row is not rolling up percentages, dates or durations. Dependencies are enabled, and the entire rest of the sheet is functioning fine (so I don't want to disable dependencies),…
- I have set up a My Tasks report for leaders, and it's not working, which is not good. They don't have access to the underlying sheet - is that why? (in which case what's the point?) It's linked to the…
- I would very much appreciate anyone's help on this. I have moved the brackets around and changed anything I can think of, but it's coming up "unparseable". The column headers and sheet references are …
- I'm trying to show on a graph how many employees we had in each quarter. How would I do that? My initial idea is to add a helper column for each quarter, and add a formula to return a 1 if any of the …
- I have researched others' questions on this and I feel this should be right, but it's not. I'm trying to return the generation based on DOB: '=IF(DOB@row <= DATE(1943,12,31), "Traditionalists", IF(AND…
- I'm having an issue where I'm regularly automating a mapped document. The input comes in via a form, the service rep makes sure all content is ok, then hits the "create PDF" checkbox. A PDF is created…
