Sign in to join the conversation:
My totals were working finally on a summary sheet but then all the columns started changing to the same formula. I tried twice to go in and reset the reference sheet range but then it would just everything on the sheet. Anyone else have this issue?
Hello,
Sorry to hear that you are experiencing issue with cross sheet formulas. I have not seen this for myself. We'd be happy to assist you directly if you could fill out the help form here: https://help.smartsheet.com/contact
Taylor
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
I have a sheet that tracks census of sheltered animals and I want to display that census cell in another sheet that matches the room number. I had a formula that pulled that but another admin had accidentally deleted some columns/formulas. In short, I want the data from the census cell to be pulled into another sheet with…
