-
Count Items from Another Sheet that Contains Partial Text
Good Evening, I am trying to count different ticket types from another sheet in my smartsheet workspace but for some reason am unable to figure this out. Below is what I am attempting to do and I hope this forum of experts is able to help. In the sheet below I have a column ticket info. This column will list all tickets…
-
Index Match - Returning a blank Value
Hi All, I am working on using an Index/Match to pull physician email addresses based on their EMP CID, which is stored on a separate physician roster sheet. =Index({Physician Roster 2024 Email}, MATCH([EMP CID]@row, {Physician Roster 2024 EMP CID},0)) When adding a physician to this sheet, if I leave the EMP CID field…
-
What could be causing inconsistent formula result?
I'm calculating HH:mm using the following logic & getting inconsistent results for the minutes calculation. The formula is the same for all three scenarios, but the Current Year Delivery is multiplying the minutes by 100 compared to the others. All the source data is consistent. What am I missing here?
-
Checkbox Question
Hello, I'm trying to make a formula so that when my "Task 100% Complete?" column checkbox is checked then it will automatically change "Fab Status % Complete (Needs Real Numbers)" column on that row is changed to 100% automatically. This saves the user of having to check the box and change the Fab Status column to 100%…
-
Using COUNTIF/COUNTIFS with OR statements
If I want to do a row count, where if Col1= 4 or 5 OR Col2 = 4 or 5, what is the best way to go about this? So for the example below, the count is 3. Appreciate any help. Thank you.
-
Is there any formula to capture the current/real time in smartsheets?
Hi there, I want to set up an automation on a sheet where, if a form is submitted/received, within an exact 48-hour time frame I can trigger the mail. From created date column, I can get the time on when the row is created. But I'm not sure about how to accurately track the passage of 48 hours in order to send the email…
-
Need help on a simple IF/AND formula but already spending too much time on it
Looking to show 'Delay' for tasks that have %complete <100% and Finish date < than Today (). Tried multiple variations but some records come right and some just ignore the %complete record. Why? Formula is: =IF(AND([% Complete]@row < "100%", [EMD Finish]@row < TODAY()), "Delay"). This formula is showing "Delay" on tasks…
-
AVG Collect with Referenced sheets
I am trying to use intake sheets to manage my regional level of data, where they will pull the basic information from the "network" intake sheet. that all works well, but I now am trying to get is the average of completion % for each project brought into the region(the the average of my 5 regions). I thought a AVG(Collect…
-
Less than won't work in my formula
Need some help I am trying to get a formula to return "Less" when the value is less then or equal to 0 and "More" when it greater then 0. The column I am comparing to is a formula to give me the totals however it appears to be returning a number based on how the column is formatted so it should be able to do this…
-
SUMIFS with Date Range & Condition
Hello Smartsheet Community, I am hoping you can help me with this simple formula. =SUMIFS([Start Date]:[Start Date], <=DATE(2024, 3, 1), Timeline:Timeline, "Tender Submitted", [Quote Total]:[Quote Total]) It is coming back as an invalid operation. Can you help? Thank you in advance.