-
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…
-
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.
-
Automation: Not Triggering when Box is Manually Flagged.
I have a simple automation but it never actually triggers. Alert 2 people (names cut from the image) if the store closed check box was flagged and the upgrade date is in the future. It never runs when I flag a line item - but the test sends it out.
-
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…
-
Send Forms via SMS
Would like to see a feature where we could send forms (or link to forms) via text messaging or SMS. Would like to send the form via SMS to the customer so they can fill out the form. Also, would like the clean looking PDF form created by the form submission to be auto sent back to the customer, instead of the Smartsheet…
-
Sheet Countdown Timer
Happy Thursday. I know many have asked this question before, but does anyone know of a way to have a column actively countdown time? Even if a plugin is needed, it will be considered. Here is what I'm looking to do. When a form is filled out and a new line is added to the sheet, I'd like the "Countdown Timer" column to…
-
Automatically copy one row when it is the end of the week or end of the month
Hello, I have created an automation to copy a row at the end of a week or at the end of a month so i can keep a log of all the calculated KPI's. This has been working for the past year. Unfortunately it stopped working a month ago for no specific reasons. Does anyone know what could be the reason? Thank you in advance for…
-
Dashboard Image Widget Opens In New Tab
Create setting on dashboard image widget (and other widgets) that opens target in new tab. Often a dashboard is a landing page for a smartsheet ecosystem. I want to always have my dashboard available. Everytime I follow a link on my dashboard, I loose my dashboard, and have to open a new dashboard. Lets have the option for…
-
Copy an automation from one sheet to another
I make different types of sheets that require the same automations, so instead of copying the sheet, it would be a big time saver to copy automations instead recreating them.
-
Unable to reply to comment with "Edit by Anyone" Publish Option toggled on
Hello! Please help me settle a debate: If a sheet is set to publish and it's set to editable by anyone, can a viewer reply to an email to post a comment? OR do they have to always access the publish link directly to respond to the comment? Someone's "Viewer" collaborator on an asset is receiving a "Your recent reply…
-
Export Cell and Row History
It would be great to be able to export the activity log for a single row or a single cell. Right now, the export of the activity log does not allow for easy filtering to a single row or a single cell within a sheet, and is limited to 90 days at a time. We document our project portfolio with each project as a single row, so…
-
Is Smartsheet HIPAA Compliant?
I work for a behavioral healty practice and we are interested in using this tool to manage several projects NON related to any patient or confidential information. We would have to integrate those record keeping systems for this to become an issue with compromising that type of personal data?
-
Member Seat Type
When a user is provisioned as a MEMBER in our internal Active Directory, do not turn them into a Provisional Member in Smartsheet unless we no longer have any available licenses in our account. The user should automatically be designated as a MEMBER.
-
Table View - Activity Log
Hi there, is there a way to make sure activity log is running when people open the new "table view" in Smartsheet? At the moment, the collaborator shows up as an icon in the top right corner, but there is no record of the collaborator viewing the sheet. If opening in grid view, the activity log works as expected. many…
-
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…
-
Is there a way to sort reports when sending them as an attachment?
Sharing a report weekly with users, the report send sorted by the first column regardless of the sort in the UI version of the report. Is there a way to ensure the report sends with the sort from the UI?
-
DataTable - Lookup Mode with multiple values
I am attempting to use DataTable to pull compliance information into a sheet. The target sheet has columns for Code, Division, and Compliance Status. I need to match on both the Code and Division columns to populate the Compliance Status. However, I need to use the Lookup Mode function to connect the DataTable and cannot…
-
Automatically Updated Reports
Reports linked better-essentially when you link a report to a folder have it update the report automatically when more items are added to the folder. If that is how it's supposed to work, the link in the folder breaks constantly for me. When you go to pull in sheets to a report that already exists, the folder and or sheets…
-
Missing column in Report if I use a formula
I'm not able to "view by" a field that I have in my sheets - Quarters (Q1, Q2, Q3, Q4) - in my report. I think it is because I have used a formula to calculate the quarters in my sheets. Does anyone know a way to get a formula based field on the dropdown for view by in my report?
-
How to record date without time
I would like to use automation on a sheet to record the Open and Closed date for a given RAID item. I don't want to record the time, however. Is there a way to exclude a time stamp from the automation? If it is not possible to exclude the time stamp, what formula would I need to use to extract the datae and time into…