-
If & Workday Formula
What is wrong with my formula? I want to calculate 3 workdays from the survey request date but only if the site plan test fit is checked…
-
#BLOCKED Error with COUNTIFS when Range columns are populated via equations
Hi, I am trying to calculate the amount of "Used Inventory" by counting the number of times "Block Date" appears between "DATE 1" and "DATE 9" but am getting the #BLOCKED error. Columns "DATE 1" through "DATE 9" are populated by equations based on "CheckIn Date" and "CheckOut Date." Below, you can see the columns in use…
-
Clean up formula building experience
I would LOVE to see a significant enhancement to the experience of building formulas. Formulas are the single most common area of confusion, and the first "step" of any builder toward enabling automation and leveraging Smartsheet. Therefore, the formula builder could use some help to take it from "just as bad as excel, all…
-
Not able to generate Stacked bar Chart using REPORT
I am trying to bring - Stacked bar Chart for the monthly county of the competency. I have generated the data via Smartsheet Report in tis format. However, when I am generating the output report. The report is not rendering as expected. I believe, I can manually build a table with competency values and month and can…
-
Combine Contacts from multiple columns into a single cell
Allowing contact columns to be combined into a multi-select contact column would make team management and index sheets much more useful. If Columns 2 through 10 on my sheet are all contact columns, a formula like =Contact2@row + Contact3@row + Contact6@row should produce a multicontact cell, not a text cell. That would…
-
Allow formulas in Assigned To when Resource Management is enabled
Currently, with dependencies enabled the Start, Finish, Duration fields do not accept formulas. Additionally with RM enabled (including the new Resource Heatmap), Assigned To can no longer be formula driven. Use case: when our Marketing team generates a copy of their campaign sheet, they have a number of pre-set tasks that…
-
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…
-
Freezing Dates
I am looking to have a blank cell populate a date in a column using an if statement to check for specific values in another column. With excel I would normally use a circular reference to check if(and()) the cell was blank and that the values I want are in another column, and then populate a today(). With Smartsheet it…
-
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…
-
Text String Help... Again!!
Hello All, feel like I am always asking these text string questions but they are so confusing!!! I have a list of retailers and I am trying to just extract the Name of the retailer between either the 1st and 3rd "-" or the 1st and 2nd "-". The problem is with how some of these are formatted like the first one and second…