-
Help! COUNTIFS Formula Logic with 2 Date Fields
I am referencing V2.0 of a shared spreadsheet that now has 2 "Created Date" fields: 1) the system generated CREATED column that will be valid for all new entries going forwards, and 2) a LEGACY CREATED DATE column that reflects when older entries were originally created (before they were imported into the new sheet. I have…
-
Formula not filling down after pasting data from Excel
Hey guys, I'm new to this and this is likely to have already been solved elsewhere, but I can't seem to find what I'm looking for. my process requires that I copy data from a CSV file and paste into my sheet where the top rows have applied formulas. The formula, however, is not filling down automatically. Any thoughts,…
-
Offline option
Is there any updates regarding implementing an option to work offline on smartsheet?
-
Revert to Single-User Contact Column from Multi-User Contact
Hello, Experimenting with the new Multi-User Contact Column, I've found out the hard way that it is treated as a separated Column Type. In other words, when running a report I need to have check 2 "Assigned To" columns. I went back to the Sheet that had the "Allow multiple contacts per cell" checkbox checked... and looks…
-
Checking box via mail
Hello, is there an option to make the check box "checkable" via mail update form? I have a column "Task accepted" and I would like to enable people to check that they accepted task via mail when they receive an update. I see that the checkbox is sent as image so I am wondering if there is a such option ( See attached…
-
Looking for a way to send an automated email when a task's status changes
One of our key uses of SmartSheet is to collect requests from our customers and manage these requests. I would really like to be able to send an email to the requestor when their request is assigned to someone on our team, and again with each status change. Has anyone developed something like this? I saw a post about…
-
Automatically send a report to slack channel
Is there a way to automatically generate a report to be send to slack. We are using slack, in part, as a scheduling tool. I have a report that generates every evening, for the next day. Can I send that report to slack? As opposed to an email list? Thanks in advance. SGF
-
SSO usin SAML question
Hello Support Community. We have setup SSO using SAML and it appears to be working fine for licensed users. Unlicensed users on our email domain are asked to create a password (therefore a new account). Can I assume it is expected behavior that only licensed users will be able to take advantage of the SSO configuration?…
-
How to flag AT Risk task
I have Planned FInish Date (Date field), and Actual Finish (Date field) and % Complete field, I want to flag the task if it's past due and incomplete. currently I tried :=IF(OR([Plan Finish]@row - DATEONLY([Actual Finish]@row) < 0, [% Complete]@row < 0), 1) but not working as intended. Thanks DJ
-
Receipt for Work Completed
I want to auto generate a receipt with Zapier or something and send it to the supervisor and client upon work completed. Problem: Our electricians perform tests on all equipment we install. We have many QC forms that we use but using them is very cumbersome. Our techs need to ensure that they print them off before going to…
