-
Certain settings get lost on copying sheets
Hi all! While Control Center is not available in my organization, my solution is to mantain a Project Template (with its own sheets, reports, dashboards, etc.) that I copy to a new folder every time we have a new project. Unfortunately I recently noticed that some settings, specifically Gannt Chart timeline options…
-
Gmail Smartsheet add-on givens error when attaching to row: "Your changes could not be applied."
Very frustrating. I get the same error every time I press Apply changes. See screenshot, very bottom in yellow highlighted box. I get this for every row every single time. It has not worked even once.
-
Return multiple values based on two cells.
Using a VLookup I was able to get the budget manager column to return the multiple values based on the paying department. However, I also need it to return another person if the grant option is selected. The budget manager column on the first sheet is used for a filter on a dynamic view to allow only the contact and budget…
-
Document Builder Formatting
Does anyone know if there is a way to remove the blue boxes on the document building and format the text (bold, italics etc…)?
-
Timescale and zoom Gantt settings copied to new sheets
I noticed that when you copy folders or sheets as "new", some settings like Gantt chart zoom and timescale options do not carry to the new copies, forcing to be updated after the fact and creating extra overhead. It would be great that those configs. would be considered structural and hence be copied as the rest of the…
-
IF Formula
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…
-
INDEX or COLLECT with OR?
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
-
Count if cell is not blank
I am trying to figure out a formula to add if cells are not blank. So for example, if the employer states he worked 1/21, 1/,22 and 1/23 the formula would state 3. Each date worked is in its own cell. I tried the following =COUNTIF([1st Travel Day Start Date]@row , [2nd Travel Day End Date]@row , "is Not Blank") I received…
-
Changing Default Calendar App View
I'm using the calendar app for my team so they can see all scheduled events, but the default view shows quarters in the past (see screenshot). I want the calendar view to start in the current quarter and show future quarters but I can't figure out which setting needs to be updated for that. Can someone help?
-
Engage 2026 - is this sign-up form legitimate?
I searched for info on Engage 2026, and didn't see anything that looked truly official from SmartSheet HQ, but I did stumble across a sign-up form: Personal Information - Engage 2026 User Conference On one hand, this is exciting because it would be geographically useful for my team, and it falls at a time of year when we…