-
How would I add in a month based off a date in another column
Hi, I am needing to create a column that will display the correct month based off a date in another column. My columns are below. I am not certain on which formula to use. Thanks for the assistance!
-
Weighted Average in Project Plans
I'm assuming that the project plan template uses a weighted average to determine % complete on the various sections of the project as well as the project overall. Does anyone know what formula is actually being used?
-
Sheet Summary formulas
Hello - I am trying to run a basic fomula on my Sheet Summary cell and am absolutly stumped! Are there limitations on how we can use formuals on our Sheet Summary cells? What I want to do add any rows from the weighted ECV column that have 2026 in the Year column. I think this formula should work, correct?…
-
How do I display the username of a modifier of a specific column?
I am attempting to display the username of a specific column using an automation workflow. I want for a user to be able to scan a barcode into column A, and for their credentials and time/ date of the barcode scan to be displayed in the next two columns. However, I want the credentials and time to be displayed of the user…
-
IF function in an INDEX formula
Hi - My below index formula works to capture the "2.0 Status" field; however, I am trying to incorporate an another piece to this formula that includes a job number. Not sure if its an IF or AND or additional INDEX function, but i want to pull this 2.0 status based on the "Project Kickoff Rec'd" line in the task AND for…
-
Date Based Automation Not Working
We have a sheet to help track when notary renewals are upcoming for staff and its a fairly simple process. We have a date column that lists the expiration date, a helper column that turns that into a total day count, status, and if an application was recvied. The trigger for this would be when that Days Until Expiration…
-
SUMIFS/VALUE
Hello, On sheet A, I have 2 columns (among many others) . Column1 contains a LEFT-formula that returns 3 digits. Column2 contains a LEFT-formula that returns 3 digits plus a hyphen and then 2 more digits. On sheet B I have a SUMIFS formula that references sheet A. If I reference column2, it works. If I reference Column1 it…
-
Need help with date reporting formula
I have 4 formulas in seperate cells that look at open and closed actions and does a count of how many there are for those months. The current formula for the current month:- =COUNTIFS({Date opened}, >=DATE(YEAR(TODAY()), MONTH(TODAY()), 1), {Date opened}, <DATE(YEAR(TODAY()), MONTH(TODAY()) + 1, 1)) works fine and has done…
-
Cross-sheet Copy and then INDEX/MATCH Help Needed
I am working on developing an End to End Testers sheet and a Defect Sheet. When a scenario test has resulted in a Defect Confirmed, I would like the Scenario ID, Scenario Name, and the Scenario Description to be pulled into the Defect Sheet. My initial approach is to break this information into 2 cross-sheet formulas.…
-
Map for Location Data
Hi, Is there any map feature that Smartsheet provides (or third party) to show on a map data of a location-column on a Smartsheet? Thank you!