-
Help Article updates May 2025
Hello Community, We’ve published the following new content: Column links overview Create column links Manage column links Dynamic View best practices To view the entire catalog of help articles, visit the Help and Learning Center. Were the articles helpful? Let us know by providing feedback for each article.
-
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,…