-
Can someone help me come up with a function to calculate a date 1 month ahead?
For example, in column A I have the date 1/22/23. Now in column B I want it to automatically calculate 2/22/23. I know how to add 30 days to a date in a formula but since not all months have 30 days I want it to show the exact date in the next month.
-
Count Columns in data sheet to appear in calc sheet.
I need help writing a Smartsheet formula that examines the "status" and "County if known" columns in a data spreadsheet. I want it to count the number of each type of status for each county. The Smartsheet containing the data is named "Test of File a complaint" the sheet where the calculation will appear is named…
-
How can my index/match formula include a column that has multiple values
Ok so I downloaded an inventory management template that is awesome! When people submit a request form for a ppe item they need, it has index/match forumlas to show us what Current Inventory remains. Its great! However, they are only able to select one ppe item from the drop down list. And I need them to be able to select…
-
COUNTIF Cell Value is Negative
Hello! I don't yet see this question put out there, so here we go: I have a column that has both negative and positive values. I would like to create a formula that counts how many negative values exist in that column. (This is for a sheet summary). Currently my formula looks like this: =COUNTIF([Delta: Projected Hours vs.…
-
Can someone help me come up with a function to calculate a date 1 month ahead?
For example, in column A I have the date 1/22/23. Now in column B I want it to automatically calculate 2/22/23. I know how to add 30 days to a date in a formula but since not all months have 30 days I want it to show the exact date in the next month.
-
CHANGE CELL IF CRITERIA ARE MET
Hello, I have two sheets, the blue one is (Sheet 1) and the yellow one is (Sheet 2). Sheet 1 are data that I got from a form, which includes the date schedule slot and timing. Now, I want in Sheet 2 to show if the date and time is chosen the status in Cabin 1 - Status is not "BOOKED" not Available. How can I do that?
-
Formula to copy all dates in a year for 120 rows?
Hi all, I need to add a formula to a sheet that will create 120 rows for the same date for all days in 2024. For example, 1/1/24 will have 120 rows, then 1/2/24 will have 120 rows and so on. Is this possible? Thanks! Jackie
-
Is there a way to "cap" the days on a sheet?
I've built a sheet that calculates the days since last event. I display this on a dashboard in chart form. However, I don't want the days to just keep increasing indefinitely. Is there a formula or a way to "cap" the days, for example ">365".
-
Formula to display next/upcoming date from a list
Hello, I'm looking to have a formula to display the next/upcoming date in the list. The formula is on another sheet (Sheet = "Helper Calculations"), so I need to reference another sheet (the one in the table below - Sheet = "Holiday Dates") within the formula. On this sheet, I can confirm the Date column is a Date type. I…
-
Duration formula Issue
Hi :) I am using this formula to calculate the days between when an action was Requested and when it was Completed, with an extra bit on the end to add the word "days" to the count result. =[Completed]@row - [Requested]@row + " days" My issue is; when the Completed cell has no date I still get the word "days" when ideally…
