-
Formula based off a selection
Hi All, Could really use some help on trying to figure out a possible formula for the below: There will be two options for freight provided, "COMPANY, and "eShipping". When "COMPANY" is selected the true cost will populate in our total cost column. When eShipping is selected I want cost *.10 to calculate in my total cost…
-
Can I put a max on a sign-up time slot on a form?
I am creating a sign-up sheet and am providing 3 signup times for people to choose from. I need each sign-up time to have a max of 15 people who can choose this time, is this possible? If so, how?
-
How to change metrics by row for Dashboard
Hi there, I have a sheet that has information for potential projects. Each project has a main row containing info that I have linked up to a dashboard. The idea is that I will pdf the dashboard with the project info, much like a proposal. I would like to make it so that I only have one dashboard and I can change the row…
-
Reset a Row
Hello, I am looking for a way to have certain cells in a row "reset" once a checkbox (in that same row) is checked. When I say "reset", I want two cells to go back to being empty and another cell to have an updated quantity. Is there a way to do this? Maybe multiple automations? Appreciate any help or ideas!
-
how to convert inches to feet and inches expressed as 12'6"x12'6"
how to convert inches(150x150) to feet and inches expressed as 12'6"x12'6"
-
COUNTIFS reference other cell, count cells with BLANK value in a column, part of formula works
I want to count how many cells are blank after they meet the range 1 and range 2 criteria. The formula works without the last part which is count blank cells. When I add the last part to the formula, it gives me #UNPARSEABLE error. What am I doing wrong? =COUNTIFS({Range1}, "xyz", {Range2}, "abcd", {Range3}, <>"")…
-
Numbering Parent Rows
I am trying to create a column for row number with parent rows only - so that child rows are not included in the count. For example, if the first row has 3 child rows, Row 1 would be #1 and Row 5 would be #2. Thanks in advance for the help!
-
Formula for yearly anniversary with month and day only
I want to set up reminders for annual review alerts. The annual review date is a formula of Completion Date+365 days, but I don’t want to have to update the year each time. I just want to put in a completion date of 2 May 2022 and have the Anniversary column return the month and day so I can get an auto-reminder four weeks…
-
Is there a way to automatically update the month formula to the next month when using drag and fill
I dragged the formulas over to May, but have to manually update the number for the month cell by cell. Example bellow. =SUMIFS({WEEKLY FREIGHT UPLOAD Range 2}, {WEEKLY FREIGHT UPLOAD Range 1}, "Pending", {WEEKLY FREIGHT UPLOAD Range 3}, AND(IFERROR(MONTH(@cell), 0) = 4, IFERROR(YEAR(@cell), 0) = 2022))
-
How to Spread Income or Costs over Months
I have multiple rows of data with the following columns: Start Date, End Date, Duration, Cost, Cost / Day and then 12 columns for each month of the year. For each row, I want to find out what proportion of cost will fall into each month. I have found some helpful tips for Excel but when I try to put into Smartsheet, I am…