-
If and Checkbox
How do I create a formula for the following? If the checkbox is check and the other checkbox is check [Total Sales]@row * [Payout Rate]@Rowena Cabiles =IF([Billable Hrs Qualify]@row,1,AND([Total Sales Qualify]@row,1,[Total Sales]@row * [Payout Rate]@row
-
Programatically changing date ranges per column
Dear all, I created a capacity overview sheet that sums the hourly allocation of co-workers between two dates, i.e. between today() and today(7), so one week from now. I would now like to extend that functionality to between today(8) and today(14), today(15) and today(21), and so on. Is there a smart way to do this…
-
Identifying duplicates between 2 multiselect Dropdowns
Hi there. Really hoping you can help as I am a little stuck here. We are using a smartsheet to log and plan change requests across a wide variety of applications. A single change will only ever be a single row with it's own start and finish dates. A single change may affect multiple applications and some of these…
-
Automatic Levels?
I'm trying to include a parent row (acting as a header) in a report if a child meets certain criteria. For example, if a child task is 'at risk' (flag is set), it will show up in the report. However, I have no idea who the parent is. I only want to include the parents of the problem children — I don't want to see every…
-
Vlookup person on other sheet, return reference if a date falls between 2 other dates
Hi all, I need help with the following: I need to find the contract reference of a person from Sheet 1 in Sheet 2, based on the name of the person and when the mission took place. As you can see below, James had a mission on the 16th of April, so I need the contract reference that corresponds to that date, which would be…
-
Managing Move/Copy Row Automation
Hello I have an employee database stored in Smartsheet. I've connected an onboarding form to a separate sheet which gathers sensitive data. I want to move that information over to the database, but not have some of the sensitive data come over with it (other people need access to the database). I know it'll drop all…
-
How do you change a row color based on the field content of a column 1?
In this case when the first column reads OPEN I need the row to be light green. When HOLD I need the row to be light red. When CLOSED I need the row to be gray. What would the formula be for this?
-
USE OF ISBLANK FUNCTION WITH HAS FUNCTION IN SAME FORMULA
Hi, I desperately need help to figure out the use of the ISBLANK function jointly with other functions. I'm fairly new using it. I have a table that has three possible values, Yes, No or the cell is still blank as we are filling the table. The purpose of the table is to track the result of an inspection in a project.…
-
COUNTIFS with reference another sheet
Hello, I'm looking for the right sentence to count the lines from a second sheet how meets my criteria. This one doesn't work: #UNPARSEABLE =COUNTIFS({Inventory Asset - Africa & Middle East Range 1}, ([TYPE]1:[TYPE]56,"Physical",[WARRANTY EXPIRATION]1:[WARRANTY EXPIRATION]56, "EXPIRE IN 24 MONTHS")) I just want to count…
-
Is anyone getting the wrong week number when using Weeknumber formula?
I am referencing the date of each entry and using the date number to trend data. The formula is =WEEKNUMBER([Inspection Date]@row), where Inspection Date is a date field. For today's date, 4/28/2021, it is returning week 17 - however, in Excel, it returns week 18. To further test, I augmented the weeknumber formula to,…
