-
Re: VLOOKUP with more than one contact
@Kristine multi contacts get complicated. Do you have a maximum number of team members assigned to a project? Are you trying to identify if all team members have liability insurance? All the mulit se…1 · -
Re: Check a box if MOST RECENTLY MODIFIED, per Hotel
@kelly906 Try = IF(MAX(COLLECT(Modified:Modified, Hotel:Hotel, Hotel@row))=Modified@row,1,0)1 · -
Re: Formula to count # of "Yes" in a single cell
@Seyer The best way I've found to do this is to hack it a little by using lengths. =(LEN([<<column name>>]@row) - LEN(SUBSTITUTE([<<column name>>]@row, "Yes", "…1 · -
Re: I want to write an auto-workflow: copy the bottom row that is not blank from Sheet1 to Sheet2
@voxdw Do you have any other automations or things changing the data in the row? Or anyone making updates to the rows? I would change the trigger to "When rows are added" instead of "W…1 · -
Re: How can I get the legend for a pie chart to display ALL series even when their current value is 0?
@ro.fei I ran into this before... @Debbie Sawyer had a great solutions for that here Basically you add a column where you take your value and add .0000001 so that none of the values are truly zero.1 ·