-
Tally of SOWs signed per month
Hello. I am trying to figure out a formula that will track the number of SOWs that have a status of "signed" per month (ie the number of SOWs signed in January, etc). This will eventually feed into a bar graph. I have the following formula so far and have no luck (INVALID DATA TYPE): =COUNTIFS([SOW, Change Order or High…
-
Avoiding Overbooking using Smartsheet Calendar/DataShuttle
Hello! I am trying to create a booking system for a room with multiple stations. Stations: 1 - 5. Time slots: Morning, Afternoon, All Day So far I have a dashboard with a calendar/form and separate sheet for the form submissions. With the calendar, people are able to see other bookings, but ideally, I want to use…
-
Formula for This week, Next week, etc.
Someone helped me with these, but I cant get them to work. Can someone let me know the error of my ways? This formula would be for last week =If(YEAR([Projected Start date]@row=YEAR(TODAY(-7)),IF(WEEKNUMBER[Projected Start date]@row=WEEKNUMBER(TODAY(-7)),1,""),"") This formula would be for this week =If(YEAR([Projected…
-
Countif Child rows with specific condition.
Hi All, Need help on the formula am using in sheet summary. Am trying to count child rows that has specific colour. Getting error #UNPARSEABLE on below formula. =COUNTIF(CHILDREN([Schedule Health]:[Schedule Health], "Red")) Appreciate the help!
-
How can I create a variation of a JOIN formula to create IDs based on quantity?
Looking at my attached image, I'm looking to use a variation of a JOIN formula to create the Unique IDs that appear in the last column. Depending on quantity, a Unique ID would be the Device Type and an incrementally increasing number (starting with "1"). The Unique ID column formatting doesn't have to exactly match what…
-
Index(Match()) Returning incorrect row
Hello! I'm hoping to get some help in finding an error in my index(match()) formula. I'm trying to pull a contact name for a customer from one sheet into another based on the customer name. The original sheet has customer name and contact email; the sheet I'm trying to fill in has customer name and I'd just want to fill it…
-
Is there a way to have a cell match the conditional formatting the referenced cell has?
I'm creating a sheet where each cell is referencing a different cell on a master sheet. In the sheet I'm creating, is it possible to have the populated information in each cell match the conditional format from its reference cell? Example: In the master sheet, if the cell contains a date that is in the past - it turns the…
-
Two checkbox columns to drive checkbox in 3rd column.
I have a pair of checkbox columns, which you can check for different criteria. I have a third column, also a checkbox column. I am trying to have the 3rd column be checked based off one of the 2 preceding columns being checked. I tried a formula "=COUNTIFS([Registered (DL)]:[Registered (DL)], 1, [Registered…
-
Formula to search contents of a cell against multiple sheets to find & return match
Hi - I have 3 grid sheets: one with client data, one with vendor data, and the 3rd I'm using like a checkbook register. I upload transaction data from our bank into the checkbook register sheet, but the transaction detail cell gives a long string of data. I want a formula that will search the transaction detail cell and…
-
Auto populating meeting date
I am creating a policy database. Part of that database I have a submission form, committee members submit policies through this form when the policy is ready for the committee to review and vote on. I would like to auto populate the meeting date based on the submission or row certation. Eliminating manual work. Not sure if…