Hi, I have a column which has multiple dates in each field as its populated from an outside software which integrates to smartsheet. The column is named "Contract First Day" and see the image how it p…
I need help with a formula. I am trying to create an index formula to get back a specific column data but i want to get the latest one. This is my sheet im referencing. the first column (Plan of Care …
Hi, I have a column named "Applied" which has dates of when an application was submitted. there is another column called "HR Review Time". the HR review time has numbers. i want to make an AVERAGE of …
Hi everyone. Im stuck with a formula and need help. this is a screensot of the sheet im working on. I have a formula in the APP STATUS column. it basically returns the status to show if all items of a…
Hi, I am trying to create a formula. i want to return a patient's status based on if that patient is found on another sheet. I have 2 sheets list of active patients available cases 7.6 I have a an adm…