-
Sum of multi select dropdown items with assigned values
I have a column (Design Software) formatted as Dropdown (multi select). The dropdown values are names of software products. I want to give a value to each software reflecting the respective cost (e.g., Adobe Substance = 3000, Browzwear vStitcher = 19000, etc.). I added the formula below in another column (Software Cost) to…
-
is it possible to list in the sheet the date of updating the sheet automatically?
is it possible to list in the sheet the date of updating the sheet automatically, is there any formula for it?
-
Column Formula with VLOOKUP using External Reference
I love the new column formula functionality! I'm converting to it whenever possible. I am trying to create a column formula that includes a VLOOKUP that uses an external reference for the data set. =VLOOKUP($ROWID@row, {~ Master List Range 1}, 2, false) I am getting an error message, and I think it's because of the…
-
How can use the Countifs function with the Today function in the formula?
Hello, I am not sure what I did wrong in the formula that I have created. When I physically count it, I would get 23 but the formula spits out zero. I want the formula to report the number of tasks that was within the last 30 days. Here is my formula: =COUNTIF({Ready For Upload Range 4}, {Ready For Upload Range 2} <=…
-
How do I return the name of the month in one cell if I only have a date (xx/xx/xx) in another cell?
I'm attempting to track the number of requests received and the months they were requested. What formula can return a Month name for a date (xx/xx/xx) e.g if I have 12/25/19 the formula will return December 2019. Please assist. Thanks
-
Trying to anchor formula to specific row
Hi, I have entered this and it works: =IF(FIND([SOP Required Group]1, [SOP Required Group]@row) > 0, "Y", "N") but if I want to anchor to Row 1, I get an #unparseable error: =IF(FIND(SOP Required Group1, [SOP Required Group]@row) > 0, "Y", "N") What am I missing?
-
Join/Collect across sheets
Hello, I think I am really close with my formula, but still getting an unparseable error. =JOIN([Freelancer's name]@row:{Feedback Range}, COLLECT({Feedback Range}, {Audition Status Range}, [Audition Status]@row), "'s ") I have a source sheet (Feedback) that contains 3 different feedback text, for three different Audition…
-
Removing Condition if the Value is blank
I have a formula that shows the Status of a milestone and it currently reads the due date (Finish) and automatically updates to off track if the due date has passed and the status if not in at risk or completed. However, I cant seem to get the formula to the point where it will not mark the milestone as off track if there…
-
Is anyone else having trouble with the Today function?
Hello, The Today function is not working when included in a simple IF statement. It was actually working a while ago but now it is not working. I tested it out by simply trying =IF(Cell@232="2",=Today(),"") but it would spit out #INVALID OPERATION. I have even tried =IF(Cell@232="2",Today(),"") but it would spit out…
-
Count, Children, Status
Hello, I wanted to create a report/dashboard that showed the total number of items under a parent and how many of those items were in a non-green status. I am entering my formulas on the Sheet Summary section. I have created the formula for count of children but am having a hard time showing count of those children with…