-
Editing rows using forms or some other android UI
I'm a freelancer, and I want to use smartsheet to schedule jobs and do basic accounting. I have a 'new job' form to create a row with customer and job info. I need a way to then add more data to that same row later, once the job is completed (total price, material cost, etc). Is there a way to do this with a…
-
File->Send as attachment isn't working
I have a sheet that I need to email as an excel file periodically. File->Send as attachment isn't working to send either PDF or excel document. I've tried with internal and external (personal) email addresses with no luck, and checked the usual spam/junk folders, so I don't believe it to be an email filtering issue. I'm on…
-
Multi-Project Gantt Chart with 1 Swimlane Per Project
Our program has upwards of 50 active projects at a single time. To assist with team resourcing, we would like to view all our projects in a single Gantt chart where each project and all its phases are condensed into one row, and project phases are horizontally stacked on the same line (swimlane), rather than children in…
-
"Save as new" with more than 100 items
Is there any way around the 100 item limit when using" save-as-new". I built a large reporting and dashboard structure with hundreds of individual reports and aggregate dashboards. The reporting structure is for a state agency that contracts with many partners, so lots of reports and dashboards for each individual partner.…
-
Get Email from Contact Name
Formula or some option to get the email address associated with the Contact name. A name can be anything a user chooses (variable), but an email is not variable and can be used to do lookups more accurately than a name. (Relying on someone to type it in correctly is asking for trouble.) I currently use DataMesh to get the…
-
Smartsheet for Outlook Add-in – Compatibility with Microsoft’s NAA and Graph API?
Hi Community, With Microsoft deprecating legacy Exchange Online tokens by October 31, 2025 (MC902782), I wanted to confirm whether the Smartsheet for Outlook add-in is now fully compliant with Nested App Authentication (NAA) and uses Microsoft Entra ID tokens and Microsoft Graph API.
-
Calculate number of days between two dates in the same column on the same sheet
Hello, Can a combination of the INDEX(COLLECT and NETDAYS Formula be used to get the number of days between two dates in the same column? I want to get the number of days between two dates on the same sheet, in the same column, that have matching names and different project types. For Example: Studio Name is equal to…
-
How to use previous cell value (from cell history) in a formula?
I have seen this question asked multiple times in the forum, but I couldn't find any clear answer provided in the answers. Please excuse me if a solution already exists, but if not, will someone please let me know if it is possible to use a previous cell value (from cell history) in a formula? I am specifically trying to…
-
Consolidated Work List by Assignee
One thing that I've found lacking in Smartsheet, compared to other products I've used, is a central location where a user can see everything that is assigned to them in one place. This would make it so much easier for our users to find what they need, quickly.
-
Unable to edit smartsheet forms without constant reboot
Is anyone having trouble with smarthsheet over the past several days? Every time I go into a form to edit it, the cursor jumps fields after each character is typed. It is so frustrating. In some cases the cursor gets frozen in a field and jumps back and forth between two fields and freezes the whole system. I have yet to…