-
Date Added when my Primary Auto Populates?
Hello! I am trying to find a way to use an automation or something of the sort for when a specific cell is no longer blank. Context: Primary Column is linked to a hidden auto-numbering column The "Date Added" Column was working for a while but every now and then the sheet will add about 5+ empty but numbered rows at the…
-
Unable to Access WorkSheet
Last night, everything was functioning perfectly while I was working on a sheet. However, this morning, I'm encountering an error message (Error 48) whenever I try to open the sheet. It's visible in the folder, the error persists on different devices and platforms. If anyone in the community has experienced a similar issue…
-
Help Article updates - April 2025
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 your security score To view the entire catalog of help articles, visit the Help and Learning Center. Were the articles…
-
Preference sheet
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 to bid on i have made this however, if there are 20+ jobs, how can i create sheet that can accommodate this. I don't want 20+…
-
Can someone please help with this formula?
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 before entering "Inactive" in the cell. =IF({Master Cadre Roster Range 1} = [First Name]@row, IF({Master Cadre Roster Range 3} =…
-
Need Help: Action required for continued Smartsheet and Outlook integration
I do not have a sys admin, its just me. so how do I fix this since I depend heavily on the plugin in my daily workflow? The Microsoft site only gives a command to check or change but I am getting this. This is super complicated I have to do a lot of things to PS and I keep on running into having to do something more. It…
-
Formula Assistance
If in a sheet our project settings call out workdays and holidays. do we need to add workday or holiday in our formulas still to take those days out?
-
Formula Help
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 the date value to populate in the cell. The N/A portion works. Formula Description is used in AI is this =IF the [Kit Type]…
-
x-sheet formula help
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 that matches a Project ID on sheet a. Here was attempt 1 that didn't work =INDEX(PERFORMANCE AMOUNT), MATCH([PROJECT ID]@row,…
-
Problem saving smartsheet spreadsheet
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 errorCode: 48