IBRIEOG✭✭✭✭

Comments

  • 嗨,保罗,是的,我可能再保险moved several hundred rows when the problem first appeared. The sheet is several years old now and I’m more experienced with Smartsheet, so might be time to review and see if I can refine or get similar results from a report or dashboard. Thank you so much for your patience and expert advice.
    inIndex suddenly stopped working Comment byIBRIEOG 05/11/22
  • Hi Paul, I have tried rewriting the formula in its entirety. The match portion worked but returned an error when index section added. When the first errors were spotted, I copied the sheet and rewrote the formulas one column at a time. Initially, the same errors were returned across the sheet. I also tried changing the…
    inIndex suddenly stopped working Comment byIBRIEOG 05/11/22
  • Hi Andree Staying well and safe thanks and hope you are too Is it a very formula-heavy sheet? Yes, I think it is on the heavy side. See below How many rows/columns? 82 rows with around 15 index/match columns, and several other columns that have mathematical formulas. Initially much larger (see below) but yesterday I…
    inIndex suddenly stopped working Comment byIBRIEOG 05/10/22
  • inIndex suddenly stopped working Comment byIBRIEOG 05/10/22
  • Hi Paul, Thanks for the prompt response. As far as I’m aware, no columns have been deleted from any of the (several) reference sheets. I have tried rewriting the formula and can only get the match portion to return the row number. I have also tried duplicating the sheet. When I did this I could get one column formula to…
    inIndex suddenly stopped working Comment byIBRIEOG 05/10/22
  • Hi Genevieve, Thank you. The Language Tool - Grammar and Spell checker add-on was causing the issue
    inTo Field remains blank despite adding a contact name Comment byIBRIEOG 01/21/22
  • Thanks Liz, It is super annoying, but reassuring to know I haven't accidently changed something on my laptop! I have logged the issue with Smartsheet support. Will post any remedies/responses here too.
    inRepeat requests to update smartsheet by refreshing Comment byIBRIEOG 03/19/21
  • Thanks Andrée, That was exactly what I needed! Have a good day!
    inWhere can I find out how much storage we have left Comment byIBRIEOG 11/12/20
  • Thanks for the prompt responses. I don’t think I phrased my question very well. Im responding on my phone so I don’t have a screenshot to share right now but Perhaps my question should be - In the plan and billing section the file storage limit is recorded as 1.3GB. I’m reading this to mean we have a maximum 1.3GB of…
    inWhere can I find out how much storage we have left Comment byIBRIEOG 11/12/20
  • Any updates on this? I am experiencing the same issue using formulas to pull data in from another sheet
    inCell linking error - URGENT! Comment byIBRIEOG 07/14/20
Avatar