Hello Community, We’ve published the following new content: Introduction to table view Large-scale sheets in table view Create, share, and apply custom themes to dashboards Admin Center: Understand yo…
I am trying to make a sheet where a colleague will be able to go through the current job bids, select the ones they want to bid on by preference(1st, 2nd,3rd ect…). If they only a few jobs they want t…
I keep getting an "invalid operation" error message with this formula. Can someone spot where I went wrong? I am not great at formulas. The goal is for multiple criteria (IF statements) to match befor…
I have been trying to work on a formula within smartsheet and only part of the formula is working and I have been using AI through smartsheet. I need help with tha last 2 parts of this formula to get …
I am attempting to write a cross sheet formula on sheet (call it sheet a) that returns the value of a column on reference sheet b, based on finding a string of text found in anther column on sheet b t…
When I try to save any changes to the spreadsheet, it loads for a long time and then gives me the error: formName: ajax formAction: fa_gridSave serverStatus: false serverStatusText: CriticalException …
Hey Guys I wonder could i pick your brains to iron out the kinks in my formula I would like to calculate a % based upon the following references Sheet Reference {EPIC} Value "GBT-xxxx" Sheet reference…
I am creating a form to schedule meetings however, I need the times I have listed in Pacific Daylight Time (PDT) to be converted into Mountain Daylight Time (MDT) (PDT+1 hour), Central Daylight Time (…
I have 22 projects with identical tracking sheets and identical automation set up on those tracking sheets. The automation has been set to run every Friday for the last month. It just copies the curre…