-
Formula help, combine and convert to lowercase
I have a formula, =[Player/Number]@row + "_" + [Product Program]@row + "_" + Gender@row + ".pdf", I would like to add to the function to convert it to lowercase as well, any help?
-
Index(Collect( Formula Help
Hi, @Genevieve P. appears versed in this issue from the previous posts I've read. I've read several posts from 2020-2021 about how to do what I'm trying to do but I can't get it right and I'm hoping somebody can easily fill in the blanks of this formula. I essentially want to VLookup based on the value in 2 columns. I've…
-
Formula Error
HI,going to pull data from my mastersheet and bring it to the consolidated sheet and for this I've tried to use this formula, i'm keep getting this unpharseable error i didn't know what i did wrong, please help. FORMULA - =SUMIFS({Order Value Sridhar Mastersheet}, {Sridhar Mastersheet Range 2,},"che",{Sridhar Mastersheet…
-
Convert data to a date.
I have a form that asks crew members what days they are available to work. I want to convert my sheet to a calendar; however, it has the date of the event and event name behind it so it will not covert to calendar view. Is there a formula so that it converts the data to date only to a new column or even a new sheet if it's…
-
% Complete Based on # of Tasks Assigned
I need a Smartsheet formula that will calculate the percentage complete for a selected cell based on the count of values in the same row in column "Assigned To (Team)" and the count of value "Complete" in the same row. We have 3 teams that complete separate tasks for one project, which is created as a new row from a form.…
-
Why am I getting an #INCORRECT ARGUMENT error when conditions meet the last IF/AND statement?
=IF([Deadline for implementing this project]@row - [Submission Date]@row < 30, 3, IF([Deadline for implementing this project]@row - [Submission Date]@row > 60, 1, IF(AND([Deadline for implementing this project]@row - [Submission Date]@row <= 60, [Deadline for implementing this project]@row - [Submission Date]@row >= 30,…
-
Automatically add formula to new rows
I have a sheet with a formula set up to find duplicate email addresses. But, when new rows are added, the formula doesn't copy to the new row. Is there a way to make the the new row also includes the formula. Sidenote: when a new row is created, it also triggers Zapier functions so I can't just drag the formula down into…
-
Why can I copy and paste my if formula in rows, but I cannot convert it to a formula column?
My IF/OR formula will not let me convert to a column formula, but I can copy and paste the formula without issues. What are the reasons?
-
Count the number of occurances of text strings
I have 2 Smartsheets. Sheet 1 contains the data. Sheet 2 is a helper that I use to drive a dashboard. In sheet 1 I have course names. I don't want to have to explicitly code for each course as new courses may be added. In sheet 2, I want to return a value that is the course name in one column and in the next column return…
-
IF Formula, Can it consider multiple columns?
Good Day, I am trying to find the best way of indicating the data within 3 columns. I thought the IF formula would do the trick. Currently I have 2 columns Unit Seal Broken (Yes/No) and then Reinventory completion. I want the formula to reflect in the Status column. see attached. Basically what we need it to do is If the…