James Gilfillan
James Gilfillan
Discussions
- Hey all, The formula below works great but I need to add criteria to pull the average. As soon as I add a second criteria, I get invalid data type. =AVG(COLLECT([Days to Release/On Hold]:[Days to Rele…
- I am not sure if this is intentional but we cannot use the send row function form a report linked to a WorkApp. I am able to send row from the same report when I access it through the workspace, but w…
- Hey all, Been working with Smartsheet for years and never run into this. I was shared as an admin (I quadruple checked I am 100% an admin on both) to two sheets earlier today and am attempting to cros…
- I am looking to be able to send row with the same columns selected each time. My team currently has to manually select each column they want to include and it is always the same set of columns. Any wa…
- I am pulling up to twenty reports off of a main data sheet and the reports are giving me the issue stated above. No change is being made to the columns listed, so I cannot understand why the reports w…
- My automation is sending an email to the correct recipients but it is sending a static form that does not allow for any updates. I have changed the columns it is sending as well as tried to tinker wit…
- I imported a simple 4 column excel document with around 8,000 rows. The columns are Item, description, UOM and cost. I am using the item and description to write a VLOOKUP on a separate sheet. For som…
- Hey All, I built out a strong sheet using strong heirarchys with a focus on predecessors looking at a few key dates. When there is a predecessor, the duration column seems to act different. Sometimes …
- I saved a sheet as new, in a new workspace, and my automation is working differently on the original sheet vs the Newley created sheet. The automation is exactly the same (Send x row in an email with …
