-
Smartsheet needs to have differentiation between a "text" column type and a number
When integrating data in other apps and programs, the data type is critical. Additionally, We need to be able to lock out the data type in the entry. I should not be allowed to type text into a date field or text into a number field. etc. This will enhance the reporting and BI usefulness of this tool.
-
Edit Lanes in Card View
Is there a way to change the field Card View uses as its lanes? When I try to Edit the lanes, all it does it changes the name of the field in the Sheet view. For example, Card View has selected the Confirmed field (a Yes/No field) as the lanes, but I want it to use the Status column as the lanes. Any way to make that…
-
Formula help
I'm looking to write a formula that looks at cell A1 and if it contains "Sent" within the text of the cell, it grabs the number in cell B1 and writes it in C1. Example: Cell A1 = "Sent w Statement" Cell B1 = $100.00 I need C1 to populate $100.00 because A1 has the word Sent within the text Any assistance is greatly…
-
Enterprise account new feature: Notification Center
Hi, Recently, there is new feature for enterprise account. Notification Center. So, even I do not open the email, I can know the notification I receive. My case is I have SmartSheet and set up 2 notification. Each notification will involve 30 accounting managers. My question is does notification center has the feature so I…
-
Reminder Notifications: translate from templates to new sheets?
Loving Smartsheet so far, and excited about finally having a truly custom system together for tracking project status for our clients, based on our unique parameters and not something superimposed! I've created a template that is working well, but would love to see reminder notifications translate from the template to…
-
Design Error for Resources Allocation - Percentage vs hours/days/weeks
Edit - I may have been a bit harsh calling this a design error, I do see cases it would be easier choosing percentages for resource allocation instead of hours/days/weeks - but making the latter an option would be an amazing improvement. The current design seems relevant for a projectized organization with dependables and…
-
External Collaboration & Communication (Outside Company Contacts)
If I send a written proposal through Smartsheet, as an attachment to an Update Request, and the client responds, I know that I will have an email verification, showing me any changes to the worksheet. However, at a future date, if our client wishes to send an approval verification through Smartsheet, they cannot use the…
-
Smartsheet and HIPAA
Hi Community ... Sharing a bit about HIPAA from the team who helped implement Smartsheet's HIPAA guidelines. Here's the very short synopsis: Smartsheet does not collect or store PHI as part of normal business operations; however, any HIPAA-subject organization with an Enterprise plan that works with PHI can enter into a…
-
reminder to change oil after 5000 miles with multiple vehicles on the same sheet
I have a spreadsheet for truck maintenance on my vehicle fleet of about 15 vehicles, and I am trying to figure out a formula or some way to send a reminder email if the truck has accumulated 5000 miles since it's last oil change. I have columns for the date, the truck I.D., a checkbox for if the oil was changed that day,…
-
Forms in a Template
I have been successfully using a template to create project plans with a form. I've created dozens of sheets from the template with no problem having the form transfer from the template to the new sheet. This morning that stopped working, so when I create a new sheet from that same template the form no longer carries over…