Jo-Ann Turning
Jo-Ann Turning
Reactions
Discussions
- I need to create a formula to count any lines that reference "GEMS Point", that will further filter only for any references within a given month. I have the following two formulas that are working per…
- Can someone help with creating a formula? We are trying to develop a formula to help create an automatic budget spread/phasing over the year. Sheet Info: We have columns named for the twelve months of…
- Hi... is there a way to edit WHO the automated workflow email comes "from"? I know it defaults to whoever set it up. But if that person moves to a new role - etc - I'm assuming there has to be a way t…
- =NETDAYS([DAW Date]@row, [Activity Start Date]@row If [DAW Date] is "blank" on certain rows, I would like smartsheet not to show "#invalid data type" in the calculation field/column. I have played aro…
- I am not sure what is wrong with my very simple formula... =COUNTIF(Quarter:Quarter, "Q1") I have a list of 700 line items and am trying to add formula to total up a count of programs 'by quarter' in …
- I have a master data sheet where a team of 30+ people will be adding 2021 data and creating our annual plan. To make it easier for them to complete the sheet, I wanted to have the ability to autopopul…
