-
Need help to adjust automatically my Order Date using Date Formula
Hi, I have two date columns in my sheet 1st column is "First Order Date" and the next one is the "Next Order Date" with underlying formula of =[First Order Date]@row+ 30, we need to supply our clients every 30 days. The problem here is that using that formula "=[First Order Date]@row+ 30" will give you all the day in a…
-
Formula to reference two values to return a third?
Hello everyone, Hoping someone can help. I am wanting to create a formula that, based on existing criteria in two cells, will dynamically return the value in a third cell. From my "Aggregator/Calculator" grid (screenshot below), from the "Health" column at the far right, I need to return six symbol indicators each to their…
-
Extract Image using Index and Match/Vlookup
Hey All - Does this exist yet? See screenshots below. Am i missing a piece in the formula? Or is my column type incorrect? I cant seem to find an article on this. I know its a bit tricky to do this in excel too - and their version doesn't work in SS. Additionally, I cannot do a direct link, because we are using the "store…
-
formula not working on row1
Hi , Can anyone help why the formulas are not working on row1.I mean i am not able to use any formula on row1 Thanks
-
Weekly progress report - project related
Hi , Need a help of team. complex one :- I have Project Plan sheet for following data below screenshot 1 I want to create a report based on status and weekly progress % Complete as shown in Screen 2 to create a dashboard chart as shown in 3 to show it in dashboard.. Can you help me on it. Also, this weekly progress report…
-
Number of day to complete less weekends
I am currently using the formula below to calculate the number of days to complete a task. Is there a way to exclude weekends. (option 1), and possibly a custom list of holidays (option 2)? =[Resolved Date]@row - [Created Date]@row
-
Date Regenerating
Hello, is there a way to have information associated with a date to regenerate Every so often? For Example, we have a sheet that has an expiration date "Designation Expiration" and all the information after that is related to falling within that time period. We would like to have all of that information repopulate Every…
-
Convert String/Text to Date Object
I have a piece of text that is coming through as 2021-06-15T00:00:00Z and I need to parse this as 06/15/2021 and convert it a Date object so that comparisons can be made on it. How would I achieve that?
-
Copying Rows To the Top of Another Sheet
Hi All - Is there any way to use the Copy function, from one sheet to another, and have it copy to the Top of the sheet it's going to?
-
Stuck in #UNPARSEABLE
I have a column titled "Department" for which there are multiple departments listed I have another column with a specific set of numbers, 0-4. What I am attempting to do is count the number of instances of 0-4 based on a specific department. I have tried this formula in multiple ways and I cannot get it to work. Latest…