-
IF Formula with Multiple Choice
Hello! I want to build an IF formula into columns when the multiple boxes has selected the right department. IF the Authorizer is marketing and finance, the emails would automatically populate in marketing and finance column. Not sure if this can be done. Would appreciate your help greatly!! Thank you very much.
-
How to count number of projects in 2023 by current status
Hi, I created a Metrics sheet that feeds a dashboard last year that counted the status of a variety of items and it worked great when there was just one year. This year, I now need to only count the items that are for 2023. In the main sheet, I have a column that has the year in a string format (it's a formula…
-
JOIN DISTINCT COLLECT or JOIN INDEX COLLECT w/ Multi Dropdown List
Hi, I want to return the "Assigned to" contact for the "Assignee Role(s)" selected in a multi-select dropdown list. Here are the formulas I've tried so far: JOIN(DISTINCT(COLLECT({Project Settings - Team Members}, {Project Settings - Contact Role}, CONTAINS([Assignee Role]@row, @cell))), ", ")) JOIN(INDEX(COLLECT({Project…
-
Fillable text box isnt show all the information?
Hello, I am having trouble with the fillable text boxes and i dont know what is wrong. I current have the sheet set up so they fill the form out and whats not working is the commas and last number of the salary wont show up on the final PDF. See below for more detail: So I am just wondering if I need a helper column to…
-
add data with hours - formula or something else
Como que eu faço para somar datas com horas exemplo (18/04/2023 15:00:00 - 06/04/2023 13:00:00 ??) Translated by Moderator How do I add data with hours for example (04/18/2023 15:00:00 - 04/06/2023 13:00:00 ??)
-
Countif Date Formula
Hello, I'm having an issue with a countif formula. I'm trying to countif the number for submissions that happened within a specific month on another sheet but keep getting an #INVALID DATA TYPE. I checked the column type in the other sheet and it is a date column. The formula works in the actual sheet with the data, but…
-
Help fix error with if and formula
I am trying a formula and keep getting an error. Here is what I am trying =IF(and([Billing Status as of 04/10/2023]="Active",[Line Installation Date]@row="N/A"), "Unknown", IF(and([Billing Status as of 04/10/2023]="Inactive",[Line Installation Date]@row="N/A"), "N/A",IF([Installation Year]@row > 1988, "Yes",…
-
COUNTIF with array constant
Hello, Can something like this be done in Smartsheet? Thank you
-
Update cells with regards to Date@row
I have a formula =IF(TODAY() = Date@row + 1, {insertDATA}, ""). Once the date hits the cell updates and I run a workflow to lock this row, however once another day passes this cell becomes invalid. How can I get this updated value to permanently stay?
-
Adding Date Criteria to formula
Good day- I have a formula that I need to add an "end date". I am not sure that between dates are available? Here is the formula: =COUNTIFS({Gate1Start}, >=DATE(2020, 1, 1), {PPV}, 1, {ItemStatus}, OR(@cell = "Open", @cell = "Closed")) The date portion needs to be BETWEEN 1/1/2020 and 12/31/2020. Right now it is just…