-
Matrix Sheet based on date and personal resource assigned
Hello all I'm a bit stumped by this and would like assistance on how to create my formulas. I'm tasked to create a sheet, view, or dashboard to summary our master data sheet turning it into a matrix style sheet. This matrix style sheet will pull data from several other databases within smartsheets. The matrix should…
-
Merged: Capability to add more than one column at a time
This discussion has been merged.
-
Multiple Line Entries with one Form Submission
It would be great feature if one form could be used to fill in multiple lines/rows on a sheet. This would be super useful for my team. As of now, form entries can only create singular row entries on sheets.
-
Formula for identifying schedule conflicts with multiple assigned people
I have been trying with no success to create a formula to identify schedule conflicts if multiple people are assigned. The formula works fine with a single person assigned. For the test case, I am using a separate table (on the left) to identify when people will not be available. The right side is representative of typical…
-
Less round and less cartooney fonts and icons would be easier to rapidly scan and ingest
I see the aesthetics of the new, rounder and softer-edge fonts and icons in the menus, but from a user access and efficiency standpoint, do not like them. I want to be able to scan the sheets in my workspace quickly, and rapidly jump between sheets, and these new fonts and design elements are harder to read at a glance.…
-
Dynamic Drop-Down
Does anyone know if the options in a drop-down can be linked to a table? I have a sheet that users can pick a "provider" from a drop down list. That provider is associated with a vlookup that helps to populate other columns in that sheet. However, the "provider" list is dynamic and changes when a new provider is added to…
-
"Use template" - can do 1 at a time and save in a folder, is there ability to do more than 1
We are setting up master templates that we want to use for a customer project. We currently can select to use 1 template and place it in the customer folder. Is there a way to select multiple templates an send them to the customer folder at the same time?
-
Return latest value from another column's latest rows
Hello, I have a sheet in Excel I'd like to move to smartsheet to work with a client's team. The only problem I have is with the fields "Previous Cumulative Partner Discount" and "New Cumulative Partner Discount" as they have formulas that involve each other column in theirs and in Smartsheet it returns the circular…
-
Direct Email Approval Button for Smartsheet Automation Workflows
Integrate a direct approval button within the email notification itself that allows users to approve or reject requests without the need to transition to a web browser. This button would perform the same security checks and record the same audit trails as the current browser-based approval, ensuring that the process…
-
Possible to Undo Sorting from a Day Ago?
Hello all, A colleague asked me for help with something in Smartsheet I could not solve so I wanted to ask for the community's thoughts! A collaborator sorted a sheet based on a particular column (in error) and were unable to undo it. This is the next day and I did not see any way to undo (additionally, there were no other…
