-
Formula for updating window of time to different time zones...
I am creating a form to schedule meetings however, I need the times I have listed in Pacific Daylight Time (PDT) to be converted into Mountain Daylight Time (MDT) (PDT+1 hour), Central Daylight Time (CDT) (PDT +2 hours), Eastern Daylight Time (EDT) (PDT +3 hours), and Greenwich Mean Time (GMT) (PDT +7 hours). I am manually…
-
COUNTIF and HAS calculations
I am trying to get metrics where if 'NDC' is found on another sheet, and it has Under Review, Pending Development or Pending Production Release, then it will calculate the total of NDC items that i have. I tried this command, but it's not working and i dont know how else to achieve it. =COUNTIF({Sabre Traveler Care…
-
Multiple Criteria in Formula
I am working on automation around Dashboards, and I am working on my metrics sheet. I have created this formula, but i keep getting UNPARSED. I'm trying to take anything with 'AF' and anything that is CLOSED and is the month of July in the creation date. What do i have wrong in this formula? =COUNTIFS({Amadeus: TC Known…
-
JOIN function in a Sheet Summary
Can a JOIN function be used in a Sheet Summary to join two or more Sheet Summary Fields? I have two separate columns that I use a JOIN function for, but I'm not seeing how I can use it in Sheet Summary (or if I even can do this). This is the function I'm currently using in a column titled Milestone Complete:…
-
NETDAYS returning #INVALID DATA TYPE
Hi - I'm trying to calculate the number of days between two dates in a sheet. I have both of my columns that contain the start and end dates set up as DATE column type. They both contain dates. I use the formula "=NETDAYS([Hotel Check-In Date]@row, [Hotel Check-Out Date]@row)". I have tried making the results column a…
-
Risk Score Formula
Hi Im looking for some help please. In for my Project Raid Log I would like a formula based on risk score to show the following symbols Risk score of 25 - 20 - Black Risk score of 19 -14 - Red Risk Score 13 - 08 - Amber/Yellow Risk Score of 0 -7 - Green Thanks in advanced.
-
Rounding to nearest Thursday in the past or current day if it's Thursday
Hello! Long time listener, first time caller — We have a weekly update dashboard that is presented on Thursdays. We'd like to have the date displayed be either the previous weeks Thursday or the current Thursday, if today is Thursday. In other words, the date should always display a Thursday date; if today == Thursday,…
-
FORMULA: Conditionally Format Cells with Errors
This is unlikely possible with Smartsheet but I'd LOVE to be proven wrong :) I'm trying to Highlight Cells in the row that have errors. There might be one to twenty columns in that row with errors at any given time. Reason for it: One broken formula (or cell with bad data) can break several other formulas in that row. And…
-
Hierarchy Formula Help
Hi Everyone, thank you in advance for your help on this issue. Currently I have a level column that gives you a number based on the level of the hierarchy the row is assigned to. I am trying to implement a column called "Topic" that lists the Task Name for Level 0 of the hierarchy for all of the children rows. My formula:…
-
Need a conditional SUMIFS formula
Hello, I have 2 grids Grid A: Project Management (used for team planning and communication) Screenshot of Grid A Grid B: Invoicing sheet (used for billing clients). I need a formula to take the information in Grid B and tell me the sum of the rows in the Task 1 column IF the sent column is checked AND the void column is…