-
Countif function within a specific month, what is my error
Hello all, I'm beginning with the functions and I'm struggling here with this instance: My objective is to add a chart to a dashboard, my information table is as follow, Basically I want to count the number of request per month and include them in a bar chart. So, I made a calcsheet to extract the information to generate…
-
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…
-
SumIf function with dates not working (and I review already a few previous Q&A of this community)
Hi, I'm completely stuck with a simple SUMIF with DATE formula. I checked already the column types, they are set as date and the column I want to sum as text/value. I tried this formula =SUMIF([WS1 Date]:[WS1 Date]; MONTH(@cell) = 8; [WS1 Attended]:[WS1 Attended]) it gives me #INVALID DATA TYPE I also tried this…
-
Multiple IF Statements Based On Symbol Color
Hello, I am trying to enter a formula in a column labeled 'Completion Status' that will show either a Red, Yellow, or Green symbol based on the conditions in 12 other columns. Every time I get close by setting 2 criteria, the other final criteria doesn't seem to work out for me. Below is a breakdown of what I am attempting…
-
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…
-
Vlookup - having trouble matching values
This discussion was created from comments split from: Vlookup function in smartsheet dose not recognize the number value? But text worked?.
-
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.…
-
VLookup doesn't recognize numbers, only text
I am having an issue with Vlookup not returning numbers (will return text). Previous users have reported similar issues but previous suggestions are not working for me. My original code is: =VLOOKUP([Project #]@row, {projectMASTER Range 1}, 2, false) --> it returns text (ie, 40100222-64) but not numbers (ie. 40100222) --…
-
Selecting info from different sheet in form
Hi all! I am somewhat struggling with a "data between cells" case that I cannot seem to figure out. I want to create a couple of forms that can be used to fill in information about a site visit. I have a sheet where the projectinfo is stored such as: client name, location, etc. The form that I've created to be filled out…
-
How to do a date range in SMartsheets
This formula works in excel but won't work in smartsheets How would I write it =SUMIFS({pMPS Active Cancelations Range 3}, {pMPS Active {pMPS Active Cancelations Range 1}Range 1,"Page",{pMPS Active Cancellation Range 4},">="&Date(11/1/21),{pMPS Active Cancellation Range 4},"<="&Date(10/31/22}))
