-
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)
-
ISBLANK Nesting
Good Morning All, I am new to Smartsheets and would like some assistance on what I thought would be straight forward and I know I am missing something basic. So the formula in English: Is DATE 2 Blank YES - then NETDAYS between DATE 1 and TODAY in DAYS NO - the NETDAYS between DATE 1 and DATE 2 in DAYS So I thought it…
-
How to write Nested IF statements each on separate line?
Hi, I have this nested IF statement that I would like to have each IF condition on a new line for easier reading and to follow coding best practices. Here is what I have now: =IF(COUNT(CHILDREN([Task Name]@row)) > 0, IF(COUNTIF(CHILDREN(), "Red") > 0, "Red", IF(COUNTIF(CHILDREN(), "Yellow") > 0, "Yellow",…