-
In-Sheet Alert/Popup Notification Feature
Requesting an in-sheet alert/popup feature in Smartsheet to enable real-time warnings for conditions like duplicates, overdue tasks, or invalid inputs. This would improve data accuracy and user experience by allowing immediate action within the sheet/report.
-
IFERROR with Index / Match from 3 sheets.
Hi All, Trying to search value from 3 sheets and using IFERROR with Index / Match and am getting Incorrect Argument error. =IFERROR(IFERROR(IFERROR(INDEX({Project Intake Project Name}, MATCH([Project ID]@row, {Project Intake Project ID}, 0))), INDEX({Completed Project Name}, MATCH([Project ID]@row, {Completed Project ID},…
-
INDEX, MATCH, and OR Function
Hello, I am trying to use INDEX MATCH and the OR function. I'm referencing 3 other sheets try to say if we find x in any of these 3 sheets I want y from those sheets. x and y will only be present in 1 of the 3 other sheets. However every I do this I either get an error code or unparsable. These are a few of the formulas…
-
I cannot get access to the admin center
Hi, For our account we cannot access the admin center, and don't know which account has access - how do we solve this?
-
Improving Proofs - Visible Comments
Feature Request: Surface Proof Comments to the Conversation Panel Problem Proof comments are difficult to discover. Currently, the only way to identify whether a proof contains comments is to manually click through every version of every proof or search the Activity Log. Proof comments do not appear in the Conversation…
-
Connect Phases in Sheet to RM
I am trying to set up Phases in our sheets to connect with RM. I have created a sheet template with the "phase' column with the phases I've indicated in the RM set up. When i go to connect the sheet with RM, the phases don't populate. I've used Cluade (ai) to walk me through and verify the set up process, and it ran into a…
-
Add dashed line option to charts for improved accessibility (color-blind friendly)
Hi Smartsheet community, I’m submitting this idea after running into a real challenge on my team that I think others may be facing too. We use Smartsheet dashboards heavily to share trends and performance data, and recently one of our team members shared that they were having trouble distinguishing between lines on our…
-
Logic Help
I am trying to come up with a formula that will change my "Has been billed" column to Yes or No based on the dropdown choices in one column and the created date, I am having trouble coming up with some logic that can work around the year with sporatic billing periods. Here is my current formula: I either have remnants from…
-
Cross Reference (cell links) from my sheet to reporting (missing data)
I have a report that is using 9 sheets, including the sheet that contains "cross reference" (cell links). I assume it won't display the cell (from that sheet), because it has no way of referencing how to reference it? In other words, the cells/columns from the other 8 sheets are common columns (except for this one), so how…
-
Collecting multiple part numbers for a customer in a "vertical" output from a form
I created a form for my customers. I'd like the customer to be able to complete one form, inputting the part # for as many parts they may need so it appears on my sheet vertically once the form is submitted. For example, John's Garage Storage has 3 different parts for order and Mickey's Kitchens has 2 different parts for…