-
Flag out of Range Date
Hello, I have a date range: Date Range Start & Date Range End, and I want to flag it if the "Actual Completion Date" is before the Date Range Start OR if the "Actual Completion Date" is after the Date Range End. Can anyone help? I've tried: =IF([Actual Completion Date]@row > [Date Range Start]@row, OR([Actual Completion…
-
auto update from multiple sheet
Hi, i'm looking for someone who can help out in setting up smartsheet for the company.
-
Stacked Bar Graph
Is there a way to create a stacked bar graph with the new charts? Thanks! Chase
-
Problem sorting report based on "Assigned to" (Contact List)
I am working on producing a report which pulls from a Task sheet (database) based on certain specific tasks and specific statuses. Each task has an "Assigned to" cell which contains a restricted list of contacts (our employees). I have been asked to sort the resulting report by the "Assigned to" column first, and then by…
-
SmartSheet / ServiceNow interface
What is the interface between SmartSheet / ServiceNow and can it be an automated rather than a manual extract which can be extrapolated into reports from Smartsheet?
-
Locking Details in Calendar App
How can I lock details in the calendar app, so users can't change the data but only view it? Thanks!!
-
Report Viewability
So I have created several Reports and have noticed that when you add them to a Dashboard, anyone with Dashboard Access can view them as a Widget; however, When made a viewer on the Report itself, all the people see is a blank page. Do the Viewers also need access to the sheet the report is pulled from? If so then reports…
-
If, Then Formula
Hi everyone, I've searched through the community but couldn't find the right solution. I need to feed specific sales metrics into a dashboard but want it to update, according to the Today column. I receive the previous months information on the 15th of each month, so the formula would need to cover a 45 day period. I added…
-
What is the best way to backup my data in Smartsheet?
My company is adding a lot of important and senstive data to our sheets and I am concerned that one of our users might accidently delete data that we need. What would be the best back to backup all of our sheets? Is there feature that will automatically backup our sheets?
-
Index(Collect(Match)) Formula Error
Hello all, Hoping someone can help me, I keep getting a "#No Match" error for my formula. I have a neighboring column with top 5 orders and I am wanting to mirror the date that these top 5 occurrences happened (using a date column that already exists in my sheet). My formula is, "=INDEX(COLLECT(Date:Date,…
