-
Display Chart of Count per date
HI I have column for End Dates and Rows for Projects. I want to show in the dashboard a chart that woudl show # of prject per end dates. Can you help?
-
Join/Collect Column Name and field value
Hello Smartsheet folks, I need to collect all NONblank fields in TEXT columns *including the column name * that contain or start with the formatted date text MM/DD/YYYY and ... also, preferably organize them alphabetically (and/or in this case ...chronologically), example... below the header row are the columns with the…
-
Combining IF/AND/OR to return a value when multiple criteria are met
Hi Everyone, I am trying to filter out tasks on my Gantt chart occurring over the next three weeks. We found a good combination of filters that works for reports, however I want to be able to create a filter like this for the sheet so that the tasks can easily be edited in real time. Sheets do not allow for the hierarchies…
-
Automating hierarchy indenting using formulas
Hello All, Is there a formula to automate hierarchy? I am trying to use Smartsheet to create a family tree and dashboard. I have created a column labeled "Generation Tier" and I am using the people/person symbol to represent where individuals fall in the generations (child=1 person, grandchild=2 people, great grand=3…
-
Report on tasks for the next 3 weeks
Hello, I am trying to create a report view of my company's work schedule that only shows tasks happening over the next 3 weeks. I have tried using a combination of filtering by start and end dates in the next or last ____ days, however the problem is that it doesn't capture every task. For example, if there is a one-month…
-
Is it possible to over ride a formula when using Column Formulas
I have a sheet where new rows are automatically added to the bottom of the sheet from a form. I want the newly added rows to have formulas added to them, which I can accomplish using the Column Formula feature. However, I want to be able to over ride the formula in some cells. Specifically, a new row is added from the form…
-
If, Then Formula question
Hello! I am somewhat of a regular Smartsheet user and I have never had an issue with the IF formula but for some reason my new sheet I cant get the formula to work. I keep getting a #UNPARSEABLE error. Basically my company has a slightly different fiscal year calendar than the regular calendar year with April being the…
-
Merged: Add a column to a row report to perform calculations to summaries / groupings
This discussion has been merged.
-
Generate Document and Maintain Formulas
I'm trying to create a construction work estimate document that automatically populates a client's name, address, customer number, date, etc. at the top of the document. The document itself contains different formulas to sum up individuals costs of the project and adds tax. When I generate the document, I can get all the…
-
Counting cells with certain criteria and within the last year
I have to count how many cells contain a certain value, and have occurred in the last year. Example: Count of all closed projects within the last year Project 1 Closed 1/2/23 Project 2 Closed 1/2/21 Project 2 Open 1/2/24 What is the right formula? In excel you can use and count if ( >=date() - 365) or something like that.…
