-
Created form is it possible to display autonumber
Hi, I have a form to created that collects data where in order to avoid storing personal information I have set up a column assigning autonumbers to every case. Now the process is that the from is filled in by one team, the second team receives a notification to update. So we need to make sure the Auto number/ case number…
-
Is there a way to record date to an individual cell and not an entire column?
Hello, I am attempting to use the Record Date automation to force my sheets to refresh automatically every day, early in the morning. This is to ensure that equations I have using Today(), refresh with today's date. Otherwise on my report pages and dashboards, tasks show an incorrect deadline status based on the old…
-
The difference between Limited and Restricted
Hello, I am hoping someone can really explain (over explain) the difference between Limited and Restricted permissions in sheet level automation workflows. I can see how Smartsheet defines it: Restricted (Default)—Only people who can view the sheet and have logged in to Smartsheet previously will be notified.…
-
Add Two Summary Fields To A Cell
Hello and thank you in advance for any help you might be able to offer. I'm just getting going in smartsheet. I've built my first sheet with Summary Fields (brief pause while I pat myself on the back). I'd like to take those summary fields and auto-fill cells in the sheet. I've figured out how to do it with one summary.…
-
Before I dive in: Roadmaps and resource summaries
Hi All, Before I spend too much time on SmartSheet I'd like to know if it's possible to create a road map of multiple projects. I'd create a whole bunch of separate projects for completely separate teams and business areas, but would use the roadmap to display each of these separate projects (ideally just one bar per…
-
Not Count Weekends and Holidays
Trying to work on a function to not count weekends and holidays. For example, if and item occured on 1/1/2021, and I want it looked at in 25 days, I want it to not count the weekends and holidays in-between. Any advice on how to get that going? Thanks in advance
-
Vaccination Status/Testing Report
Does anyone have an easy solution to tracking employee weekly testing? My thought is that any employee that shows as unvaccinated will receive an alert each week to upload their test results. (I don't have a problem setting that up). From there, if an employee doesn't upload the test results each week then an alert will be…
-
How do I prevent rows from being copied across if the target sheet already shares a cell value?
I am trying to create a system to track changes to cells. For example, if an order gets changed, I have automation set up to copy this row to another sheet. This way, I have a separate sheet with all the changed orders, and can then inform customers of delays. The problem I am facing is that if the same order gets changed…
-
Edit permission trouble shoot
Recently i shared a sheet with my colleagues with Editor permission. but they get only view access when they log in to the sheet. However the edit is working form them on mobile app.
-
Reason why formula driven date changes when sheet is saved
I have a sheet where we use the below formula to calculate the due date for a task. There is a reoccuring issue where when a user saves the sheet these dates are updated, not because the user made a change to the cell itself. It seems to be system driven. It toggles back and forth between a few days. I cannot for the life…