-
How to obtain access to WorkSheet Home without following 3-leg OAuth process
Hi. We are using SmartSheet to store multiple sheets that should be created by one person. This person will share one or more sheets in each of multiple workspaces. I am writing an application (in C#, hosted on AWS Lambda) that must access each Workspace, and Sheet, and read each Sheet. I am using the official SmartSheet…
-
Metric Sheet -Showing Trending
I set up a metric sheet that with CountIfs formulas to show Monthly Stats.. I just realized that when I change the reporting period on my source sheet , I will lose the value counted in the previous reporting period... Is there a way to lock the data values in the previous reporting periods... arggh
-
Index, Match, Parent
I'm trying to dynamically change a cell's value depending if a checkbox is checked or not. Directors of a project would like to know what stage a project is at and if that stage is on target or not. Where I'm running into trouble is the directors only care about the Parent Task and not the child tasks. This is what I have…
-
Smartsheet Consultants Needed
Hi community, Our organization just purchased Smartsheet Enterprise License - and is looking for consultants to build the solutions which require API integration. We have contacted with Smartsheet internal team and they quoted us $12,900 + extra travel expense, just for 2 days on-site "discovery and planning workshop",…
-
Charts with no data
I have a dashboard that I update weekly to show any applications that were processed through our office. Sometimes, there are weeks where we don't have any applications processed, so I don't have any data for the week. Is there a way to customized the error message in the chart? I've included a screenshot. I just want it…
-
Update/Approval request after declined
Hello, I am using Smartsheet for budget requests. The alerts & actions are set to send an approval request when the requester submits the online budget request form. If the approver declines the request, an update request is sent to the original requester where the comments, attachments, dollar amount can be updated. How…
-
Extract location data from attachment (picture)
We are using our sheets for sidewalk repairs. An inspector in the field will open the form in the field, on his phone, fill out the basic information (type of work, address). The sheet will auto-populate the date, but I also want it to auto-populate the location. I was thinking if he were to take a photo, both android and…
-
Formulas for an automatically generated Risk Level
Hi I'm am trying to replicate the below formulas in smartsheet so it can automatically calculate the Risk Level with existing controls and with additional mitigation. The below formulas are currently being used in excel: Formula for existing controls Risk Level: =IFERROR(VLOOKUP(H7&I7,LikeliConseq, 2, FALSE),"") Formula…
-
Radar Charts
Hi, I think the graphs implemented last year were an excellent and needed set of features. I still however have to use PowerBI for some of our charts. This is problematic. Can we get Radar Charts into the Graph Types?
-
Red Flag If statement
I have an if statement that is doing what I need except when there is no value in the deadline column. I want to keep the functionality I have but make sure the flag is not red when I have no deadline set. =IF(AND(Deadline2 < TODAY(2), Completed3 = 0), 1, 0)