-
JOIN & CHAR and blank cells
Hi - I am joining cells in a row that may or may not be populated with data. I need to pull them all into a single cell to map to a document. I've managed to pull them all in using this formula: =JOIN([PF Employee Health & Knowledge]@row:[PF NSM Logs]@row, CHAR(1)) The issue happens with mapping. When a cell in the row is…
-
How to count within date range by name of event and name of employee
Hopefully I'm asking this correctly. I need help with a formula to count the # of events an employee managed by event type and within a date range. Example below: Date Column Name: Event Scheduled Employee Column Name: Employee Employee: John Event Column Name: Event Type Event: Birthday I would like to count how many…
-
Formula for business days
Hi! Is there a way to do a formula calculating a date plus x no. of business days. For example, I need 7 business days from the time something was approved. Right now I have =[APPROVEDDATE]1-7. But this is giving me the date 7 calendar days from the Approve Date. I need it to give me 7 business days from the Approve Date.…
-
Formula ideas
So here goes; sales sheet - contains sales monthly by postcode (RevPC} and name {RevPN} Sheet B - wants a formula to pull monthly rev data from the sales sheet if postcode and name match I just cannot get it right and cannot think where to start whether if statement and vlookup etc, sumifs .... help please??
-
Percent Complete Plan Formula
Smartsheet Community: I am Tracking Plan VS Actual and have a % Complete Formula to Track The Plan. However, My Formula is at 100% Complete for Plan, but the due date is 11/28/22. Therefore, it should be Calculating 100% Complete as of Today. Does anyone have any idea where in my formula is incorrect? % Complete (Plan):…
-
Formula needed to show project week
Hi all, I'm trying to put a project week column in my timeline, and I need it to return the actual project week and not the calendar week when looking at the start to finish date. Example: If my project started on 31/10 this will be week 1. The formula looks at the task start and finish date and returns - 1,2,3. This is…
-
Roll-up multiple projects by "assigned to" and NOT TO BE A REPORT??
Hello beautiful community of SmartSheets, The client wants to use the card view of smartsheets but not in smartsheets itself but via Microsoft Teams, which is a great integration platform, the problem is that when you integrate a report via teams, is "View Only" so the client can't move the cards around or check tasks that…
-
If cell A contains specific data, populate cell C with data from cell B
Hello Smartsheet Community! I hope that everyone is well and had a Happy Thanksgiving, for those of you in the States! I need some formula assistance for what I'm trying to accomplish. I have (3) columns: A - Veggie Type, B - Veggie Qty, C - Total Potato Qty If A - Veggie Type is "Potato", I want the C - Total Potato Qty…
-
Count Number of Cells that Contain Certain Text?
Hello, I am trying to count the number of cells that contain certain words, such as "NYSEG" or "RGE," when the cells may contain more than one of these words. I have tried using =COUNT(FIND("ConEd", [Utilities]:[Utilities])), but it always turns back a 1 (no matter how many cells actually contain "ConEd"). I am trying to…
-
Unparseable Error
I'm getting an error #UNPARSEABLE for the following conditional formula that sets Red, Yellow, Green, Blue symbols per combined conditions of [End Date]'s proximity to "TODAY" + Status Condition (Not Started, In Process, Complete): Formula:…
