-
Need To Figure out a way or a Formula
How do I split the numbers into the same sheet when they are in a same cell like an array which has been brought to that cell using a formula. Eg: i have 182,183,184…. in one cell and I want to split them and create a row for each number on it's own. How do I do that?
-
Conditional formatting using multiple columns
Hi! I feel like I'm making this harder than it has to be- I have a max inventory column and sold column, and I want to use conditional formatting to make oversold = Red, sold out =Yellow and inventory available =green. I understand I need a helper column, but can't figure out the correct formula.
-
Last working day of the current month
I need some help with the following formula: =WORKDAY(DATE(YEAR(TODAY()), MONTH(TODAY()) + 1, 1) - 1, 0) The formula stopped working this morning, and is now showing #INVALID VALUE instead of the date (I'm expecting 12/31/2025). Can someone tell me what is wrong with the formula that it's not giving me a date?
-
Sum based on two columns, words and sum numbers
Hello, I am trying to figure out a formula that will SUMIFS my first range says "Perfect Match 111" and my second range has a number in it. Example if "Perfect Match 111" is in my first range 3 times then I want it to sum the number that is in my second range. So below I would want 6 to come back to my sheet. I have tried…
-
how do you copy an old smartsheet
We track Time and Effort on Smartsheets. Once the form is filled out we need the Smartsheet to move on to the approver. Nothing is working like it did last year.
-
How to find a missing contact
I have a multi-contact column where I assign users to a task [Assigned To]. I have another column where one of the assigned users selects their contact once they have completed their portion of the task [Completed By]. I want an automation that sends a reminder/Update request to Assigned Users that have not Completed their…
-
Formula to tick a box if two conditions in another sheet are true.
Hi, I am trying to use a formula to tick a box in Sheet 1 if the following conditions are true: The email at row (Text Contact) in Sheet 1 matches the Email in the deployment sheet (Email Deployment) and the Event in the deployment sheet (Event Deployment) is equal to "Event Name". The event column in the deployment sheet…
-
how to make a sum for each day automatically ?
as you can see in the picture bellow, I want to make a function to generate an auto sum for each day where any time day changes, I get the sum directly of the same day. P.S: numbers in DailySum are random and for AmountIQD it has this function =[مجموع الاليات]@row + [مجموع العمالة]@row + [مجموع المواد]@row your help is…
-
Military Time
I have a column that the time input is in 24 hour time, but my staff will use 0700 instead of 07:00. Can I create a formula that will change 0700 to 07:00?
-
Can I use the formula COUNTIF to give me the number of hires by week?
Hi, I have my COUNTIF formula started to show the total number of hires in each category type however I need to further break it down by week. Ideally showing the number of hires within the next 7 days per category. I am feeding this sheet into a metric widget on a dashboard for others to view and would like to not have to…