Brian_Richardson
Brian_Richardson
-
Re: Why are dependencies needed for the Smartsheet/RM integration
Duration can. Then End gets calculated.1 · -
Re: Data Shuttle with duplicate entries
Ok - you're using Data Shuttle to import data, not Data Mesh to merge data. Data Shuttle works differently from Data Mesh. It will only do a one-row update for any given unique ID. If you want to upd…1 · -
Re: Collecting Duration a Row is on a Status
Hmm. You'll get INVALID VALUE when the COLLECT cannot find any rows that meet the criteria and then INDEX tries to return the first value from the COLLECT…which is non-existent. So, does your sheet h…1 · -
Re: Collecting Duration a Row is on a Status
It’s because your Created dates are all exactly the same. The formula is looking for Created dates/times that are later than the current row Created date/time, and it’s not finding any, so there’s no…2 · -
Re: Collecting Duration a Row is on a Status
Oh, if you don't care to have the status durations per project, but instead just want to get the average duration for all projects for their 1-Not Started value, then that's simpler. =AVERAGEIF({Stat…1 ·
