-
Hi! Can someone please help me with writing a formula for my summary field?
I need to count rows if “Target Start” is between the Friday before last Friday and last Friday, “Work Type” is "EMERGENCY”, “Work Order” does not contain “IMP”, “Status” is not one of “Cancelled” or “Closed - Out of Scope” I've tried: =COUNTIFS({Target Start}, >=TODAY() - WEEKDAY(TODAY(), 2) - 2,{Target Start}, <=TODAY()…
-
How to Import MS Project File into Smartsheets, but with the Time stamps from MS Project?
When I try to import MS Project File into Smartsheets, it automatically treats the import as a project and hence the result only appears with the Start Date and Finish Date, and I lose the time stamps in from my MS Project File. I also tried taking an export of excel file first from mpp., but as I export to Excel, I lost…
-
Reference cell value from a different Smartsheet
Hi Smartsheets community, I was wondering if anyone would know a way to reference a project ID from a separate Smartsheet by searching for Project name and returning the project ID. I was previously manually searching and linking them across the 2 smartsheets BUT: Sometimes new line items are added to the master list…
-
Month Today formula for previous year's month?
I'm curious to see if there is a formula out there that I am missing. Currently this formula takes this current year and subtract one from it and also references a month based on a monthly column. So instead of having to reference 2024 in the formula I can say year today minus one to reference that year. I'm curious is…
-
Merged: Provide method to disable "Used in formula" Pop-Up
This discussion has been merged.
-
Formula help on RYG Balls for Baseline Variance
hello all I'm struggling with this because the variance is in Days. I did a basic IF statement where: if the Status = complete then Green, and "nested if" if the Variance was < -5 then Red else Yellow. It just turned complete things Green and everything else yellow, because the variance is in Days (eg. 1d or -2d not a read…
-
One template with scroll down options for different timings of tasks
Dears, As we know making formulas in duration time is not possible, so I'm looking for other option to make life easy in below scenario: We have several production plants, producing different product types and using different packaging pritnters which has influence on overall project timing for new product introduciton. I…
-
Create "SAVE FORMULAS AS TEXT" Option in Backups, Exports, Snapshots, etc.
My tiny brain says that this feature request would be fairly simple to create, and I know it would make many of us very happy. FEATURE REQUESTED: Create an option to "Save Formulas as Text" when doing a "Backup", "Export", or "Snapshot". If checked, the system would place a special character in front of all cells in the…
-
Referencing a cell from a row based on a formula? MAX/COLLECT or something else?
I'm using this formula in my TASK sheet to find the most recently submitted invoice for each TA from my INVOICES sheet: =MAX(COLLECT({Invoices Range 3}, {Invoices Range 1}, TA@row)) I want to add a formula to show the DATE PAID field from that same row of the most recent invoice. I cannot simply use the same formula to…
-
How to add the first digit in a cell along a row
I used smartsheet to do a survey. We used numerical rankings with a description, (for example: 1 = Not familiar, 10=Very Familiar) as drop down choices in the form. Now, we want to add and average various columns that contain the responses. Is there a way to do that? Just capture the first digit vs the verbiage so we can…