-
Sum column if another column is not blank
Hello all, I am trying to create a formula that will only sum budget cells that have a date in another column, if the date column is blank then those budgets would be excluded from the total sum. I'm having a hard time finding any formula that will work, possibly because these cells are linked from another sheet? Any help…
-
Why does my Metrics constantly stop calculating correctly?
I've been making a "Metrics" sheet for some time now, and in the beginning everything was calculating fine. But it seems to be when I add more "data tables" if you will, or more metrics, some tables stop calculating correctly. Here is what my sheet looks like for a better understanding So, the first few-ish sections will…
-
he3lp please
am trying to create a sheet that can autopopulate a column based on the information put into another... but the problem is the column that needs to autopopulate is a contact column with is set to contact list so that when name in that column is entered it will notify that person. (Debbie@ brickability or john@brickability…
-
IFERROR LOOK UP
Hi All For our timesheets we use IFERROR to check another sheet against a job number, I now need this to check over multiple sheets not just 1 how can I do this please? The current formula is below. =IFERROR(INDEX(COLLECT({PMYS Job Tracker - Boat}, {PMYS Job Tracker - WIP}, WIP@row, {PMYS Job Tracker - Line}, Line@row),…
-
Is there any way to take a certain row of cells from an Excel Sheet and bring it to smartsheets?
I have multiple sheets on excel in which they track improvements continuously and would like to have the data automatically transferred into smartsheets as I have a master of all the excel sheets. Is there a formula or an add on that can allow this without having to manually copy and paste it every month? For example every…
-
Calculate amount of days untill deadline and how many days is overdue
Hi Hoping you guys can help! I'm trying to calculate the days between a desired deadline and today (so kind of a countdown) and in the same field then also count if the task is overdue and by how many days. so, I was thinking, if it was counting down the days, it would be a positive number and when/if a task is overdue the…
-
Stuck on a COUNTIFS formula where I want to exclude rows
Hi Smartsheet Community, I'm stuck on a COUNTIFS formula where I want to exclude rows. Where I'm at using dummy text is below but know it's not right, just not sure why. =COUNTIFS({Sheet Name | Column A}, "ABC"), {Sheet Name | Column B}, NOT (CONTAINS) "123", "456") Thanks in advance!
-
Rolling 12 month - need to mark line items in a sheet if they fall in the last 12 months
I have a detail sheet where we gather data as projects are closed. We want to be able to have reports and dashboards for the current year as well as the last 12 months. I have current year figured out without any issues, but I am struggling with how to filter for a Rolling 12 month period. I have created a Metrics Sheet to…
-
Link an entire column from one sheet into another sheet
I have one sheet with ticket information. The other sheet has tasks for that ticket. I would like the 2nd sheet to automatically grab the ticket # from the first sheet and add it to the 2nd sheet so the related tasks can go through a checklist. How do I accomplish this? My ticket number column is called Case # in both…
-
IFS and IF AND
I wonder if someone could help me? I'm getting an 'INVALID' error for this formula: =IF(AND([% Complete]1 < 1, [End Date]1 < TODAY()), "Red", =IF(AND([% Complete]1 < 1, [End Date]1 < TODAY(5)), "Yellow", "Green")) If I use the 1st part: =IF(AND([% Complete]1 < 1, [End Date]1 < TODAY()), "Red","Green") it works, but I want…
