Hello, I have a need to be able to highlight if a range of dates falls between any other range of dates. I have a checkbox column which needs to be ticked if a range of dates conflicts with other rang…
Hi, I have an action plan with an action column, a delay column, a referent column, and a progress column. I would like to create a workflow that sends a notification (mail) to the referent of the act…
Hi, has anyone figured out a way to send an approval request for more than one row at a time? I have rows that all need approved that need to be sent in the approval request along with their informati…
Hello! I am an admin at workspace of the company. I can't take ownership of sheets from an existing user with business license. I have this message when trying to get ownership: You cannot take owners…
Is this possible? I have a checklist sheet, with multiple questions set out in each row. Id rather avoid making each question a column so would it be possible to create a form based on the questions i…
What about a sheet to roll up all open tasks of each project owners sheets so a managed worked flow to request updates would include all updates needed for all the project owners sheet actions? This w…
Hi everyone, could I please ask for a sense check here? I have set up this Workflow. There are several different people in the 'Assigned To' column, and when any of their dates change, I would like Ch…
I am trying to develop a formula to flag tasks that are less than 50% complete but more than 50% of the duration has passed. I'm not sure if my math is correct. But aside from that, can Smartsheet per…
Hello, I am trying to create a nested IF formula based on the criteria below. Below is also a screenshot of what I am trying to do: =IF([% Complete]1=0,"Not started" =IF([% Complete]1>=0 and <=1, "On …
Does anyone know how to create a calendar that allows multiple entries per day, and shows time slots such as a meeting for example? Basically looking for a calendar in smartsheet that resembles an Out…