Sign in to join the conversation:
I created several fields in the summary sheet. Is there a way to use the filter option in the grid to update the summary fields? I created a date between filter and want it to apply to the summary sheet. Currently it does not work together.
Unfortunately you cannot filter the Summary fields. If your summary fields are populated via formula, there may be a workaround, but it could potentially get a little complex. Feel free to Submit a Product Enhancement Request when you have a chance.
I have Timesheets and would like to create Invoices. Right now I have 2 sheets, Timesheets and Invoices. One person can have multiple timesheets for the month. Can I move cell contents from 3 Timesheets into one row on the Invoice? I have tried a Join/Collect but it is only capturing one row. Thanks!
I'm trying to set up a formula to calculate merit increases but, I keep getting "#UNPARSEABLE" in my cell. Can someone tell me what I am doing wrong? thank you! =if([Salary Per]@row ="Hourly",[Proposed Hourly Rate]@row *2080, if([Salary Per]@row ="Annually",[Current Salary Rate]@row *(1+[Increase Percentage Salary]@row…
Pretty sure this a Friday afternoon brain lapse…. I need to pull a value over if one of two conditions is met. I need the {Request Number} from Sheet B IF [Case Number]@row matches {Case Number} on Sheet B OR IF [Person]@row matches {Person} from Sheet B. Thanks!1
