Kelly Moore
Kelly Moore
-
Re: Display most recent entry/value (by date and time) into a dashboard
Hello @kimkummer One approach is to add a helper column to your source sheet (a checkbox column will work. This is Sheet1) to flag the most recent date. You can push this column out of the way and hi…1 · -
Re: Index Collect or Index Match
Hey @Michelle Fayed Your approaches are good, its the syntax that needs to be tweaked. With only one criteria, typically INDEX/MATCH is used. =INDEX({Status}, MATCH([Service Request #]@row, {Service …1 · -
Re: Default one field value based on item selected in another fields dropdown
Hey @k_Hunter001 I'm sorry for the delay. I took advantage of the US holiday week. Your Sponsor-Approver field must be a contact field if you intend to use this field to send notifications. If you do…1 · -
Re: Default one field value based on item selected in another fields dropdown
Hey @k_Hunter001 To make the formula always populate new rows you will want to turn the formula into a column formula. You do this by right clicking INTO the cell where the correct formula resides, a…1 · -
Re: Default one field value based on item selected in another fields dropdown
Hey @k_Hunter001 If these criteria given above are not met, then is the response "(Not Required)"? The screenshot above is truncated so I cannot see the full response. Is there ever a time …2 ·
