-
How to use If and and?
I have 3 columns A, B, C I need to write a formula that will return Column C based on the values of Column A and Column B. If Column B=3 AND Column A is between 3.5 & 4.4 then return 4 If Column B=2 AND Column A is between 3 & 3.4 then return 3 If Column B=2 AND Column A is between 3.5 & 4.4 then return 3 I am able to…
-
Index Match Across Multiple Sheets
Hello Smartsheet Community! I have reviewed a few similar posts on this subject, but have further questions ... Examples shown on other discussion threads, show to use stacked IFERRORs, and repeated Index/Match in the formula to look at multiple sheets, however I am not able to get this to work. When you're stacking…
-
Countifs Formula Referencing Another Sheet
I could use some help with a formula that references another sheet. The sheet I want to reference is titled: Certified Roster Status The sheet has a number of columns. But, there are two columns for which I want to use the criteria for the count. I’d like to get a total count from the column called Status when the word…
-
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…
