Dashboard widget cant save as it request data validation

hafiz ✭

hi im using smartsheet trial version. im trying to create a dashboard of my reports from various sheet but it cant be saved and requesting for data validation. can help me on this?

Tags:

Dashboards

0 ·

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Trending in Formulas and Functions

COUNTIFS with OR
Hi everyone. I have a formula for which i have multiple criterion. The issue I am having is for one of the columns, I want it to be counted if it contains "x" or "y" or "z". I cant figure out how to phrase it appropriately and make it work. Here is my stab at it (but it doesn't work). =COUNTIFS({New Disposition Tracker(All…
AVG COLLECT GREATER THAN VALUE
I have a formula to calculate the average amount within a sheet. I want to change the formula to only collect and average any amounts that are >£10,000. =AVG(COLLECT({Archive Sales Amount}, {Archive Sales Stage}, "4 - Closed Won", {Archive Sales Level 1}, "1")) Thinking I may need IF and @cell but it keeps giving me…
Counting Days with plus or minus options
I know, I know… use =Networkdays([start date]1, [end date]1) HOWever, I am trying to track the performance of when a job is completed according to its due date. I found adding a -1 to to stop the inclusiveness of the calculation, whereas I can get a job completed on 10/5 that was due 10/6 to show 1 day using…

Dashboard widget cant save as it request data validation

Help Article Resources

Categories