-
SUMIFS question regarding multiple criteria to summarize a cost column
I have two sheets I am using, one is my master sheet where I am collecting this information via form I created and the second sheet is what I like to call my data sheet. I got the formula down for if it's domestic or international, then calculate the sum. That's perfect. But I am trying to further break it up by month and…
-
Formula for determining whether a date occurred during daylight savings or standard time
I've got a sheet that I'm using to track the go live dates of items for a project I'm working on. These always go live at 10:00am in my local time (PST/PDT). The go live timestamps for these items need to be entered in UTC on the backend, when means the times need to be entered as 18:00 if the item's go live date is during…
-
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.
