Trending in Formulas and Functions
-
ISO Formula to pull data from one smartsheet to another
I am trying to pull a site number from one smartsheet to another based on the date. So when smartsheet 1 is updated and a site moves to another date, smartsheet 2 is updated. Smartsheet1 Smartsheet2 End Result on Smartsheet2
-
VLOOKUP Output Doesn't Match Expected Value
Hey Everyone, I've been having a hard time with some missing features or current limitations within SmartSheet but have found the communities helpfulness in finding various work arounds very useful. I'm hoping that somebody will have an idea for the issue i'm currently running into now. Having made some helper columns…
-
What is wrong with this formula?
I am trying to summarize the quantities of each different sized container that is also checked as being shipped off-site to use in a dashboard pie chart. I tried the following formula, but I get '#unparseable'. What do I need to fix? Or coincidentally is there a better way, using reports, dashboards, however, to visualize…