Sign in to join the conversation:
I'm trying to calculate the number of working days between two date columns in Smartsheet, but I want to exclude weekends from the count. Is there a specific formula or workaround that I can use to achieve this?
You'll want to use this function in your formula:
NETWORKDAYS Function | Smartsheet Learning Center
I'm trying to find and number in the Rank column the last two rows that have a status column with a check in the checkbox. I am using the following formula but am getting a #INVALID OPERATION error. =IF(AND(Status@row = 1, [Row #]@row >= LARGE(COLLECT([Row #]:[Row #], Status:Status, 1), 2)), 1, 0) The properties for each…
Objective: Status column is a drop-down. The cells in the Status column have a formula using Descendants, with the idea that when the descendants tasks are all marked with the same status, such as "Completed," then the ancestor to those descendants is also auto-marked as "Completed." Example: See screenshot below. When…
I am attempting to display the username of a specific column using an automation workflow. I want for a user to be able to scan a barcode into column A, and for their credentials and time/ date of the barcode scan to be displayed in the next two columns. However, I want the credentials and time to be displayed of the user…
