I have a form that has a status of sick or returning. There are other columns but not needed for the formula (other than name). I want to add a helper checkbox and when someone submits a form for retu…
Hi there - first question ever! Also - not great at using the right language so sorry if it's a bit confusing! I am currently trying to use a formula to count if a certain condition is met in column a…
Hi all, I have a published report and my leadership would like there to be a way to 'click on the contact' in the report to be able to send them an email. I'm pretty sure this can't be done in Smartsh…
This might be unrelated to the Windows 10 update, but it happened at the same time. In Chrome, she can no longer see some of the drop downs on a sheet that has been shared to her for quite some time. …
Hi, I would like to build a sheet to collect inputs from my team across the regions to share to the entire team the planned “out of office” period. These could be half day (morning or afternoon) or fu…
I want to be able to have a formula that pulls the average number of projects we complete monthly for our sheet summary. I have a date column for "Date Completed". Can anyone help with what the formul…
Hello Smartsheet community. I am in need of a solution that allows me to leverage an intake form to track Objectives and Key Results. I need to be able to sequentially generate unique ID's for each Ob…
I'm looking for some guidance with this formula. I can't seem to get the numbers to add up if the condition is met. Essentially if the cell is "No" a number should be added and the number is different…
Hey All, I think I have all my ducks in a row here, but I continue to get a #INCORRECT ARGUMENT SET Error. Trying to dynamically set a status indicator. Can someone assist? For more info: [Assigned To…
I have a sheet that contains cells that are populated from a multi-select drop-down. Many of those cells contain two or three separate values. When I export the sheet data to Excel, those multiple val…
