-
Total Hours Worked
I am trying to find the sum of the total duration of hours worked. When I use the formula =Sum(Children()), It comes back in with a "0" value. I tried adding a column to convert the "Duration" to an actual number and I am getting "Invalid Value." when using the AI recommendation formula of =VALUE([Duration]@row) Any…
-
Trouble with multiple checks using MAX/COLLECT
I have a set of data for monthly KPI's. The user may enter the same KPI with a different dollar value multiple times. Once I identify the last entry for each combo of calendar month, fiscal year and metric, I will use that data on a report to show the user the value that we'll include later down the road on another report.…
-
I need a formula for symbols based on IF function
Hi, I need 2 formulas for "due date calculator" column and "due date status" column In the due date calculator column, i used this formula, which works good, but i need one change in it, if done column is checked then i need to return someother value in the due date calculator like "complete". =IF([Due Date]@row <=…
-
VLOOKUP Rejection Followup Help
Greetings- I have a grid that my staff enters half the data (white half below). The right half below comes from a form to another grid and gets pulled in via a VLOOKUP. On the form, the person has to select the correct slot number and that corresponds with the slot number row on the grid below. The question and issue I'm…
-
Compounding Numbers from Previous Row
Hello, I have read through a few posts on referencing the above row and can't seem to get anywhere. I need to compound the % of the total revenue from the row above so eventually I will reach 100%: Does anyone have any ideas on how to achieve this? Thanks!
-
Suggested formula not working
I found out you can't return a column name in a formula, so I added them into the first row. I am trying to find the name of the fruit associated with the highest value, 2nd highest value, etc. Smartsheets suggests: =INDEX([Apple]1:[Clementine]1, MATCH(MAX([Apple]2:[Clementine]2), [Apple]2:[Clementine]2, 0)) but I get an…
-
Calc a beginning of week as Monday
Hello. youd think this would be a simple calculation, and Im finding it works every day but on Sunday. currently using =[Created Date Only]@row - (WEEKDAY([Created Date Only]@row) - 2) to calculate the starting day of the week as Monday. Ideas on modifying it so that Sunday will calc as the previous Monday? Thanks
-
Two sets of generated task numbers based on Prefix
Hello, I have a sheet that is tracking submitted occurrence reports. I need the numbers to be sequential for two different prefixes OR- and SAFOR-. Example OR-1000, OR-1001, OR-1002 AND SAF-1000, SAF-1001, SAF-1002. I don't think I can do this with an auto-number column, but any suggestions on how to do this? Thanks, Ashley
-
Formula to check a box based on two conditions
I have a sheet with a client name on the sheet 1. I want to check a box on sheet 1 based on the values on the CRM sheet. If the CRM sheet has the client name on sheet 1 and the offer status column is "Accepted" on the CRM sheet, I want to check a box on sheet 1 next to the clients name. They may be listed in the CRM sheet…
-
How can I return a blank when none meet critera?
=IF(AND(COUNTIFS({Case Consultation Tracker Submission Date}, >=DATE(2024, 8, 1), {Case Consultation Tracker Submission Date}, <=DATE(2024, 8, 31), {Case Consultation Tracker Range Status}, <>"NOT Case", {Case Consultation Meeting Number}, =1, ISBLANK({Case Consultation Tracker Submission Date}, =true, "")))) I want to…
