I have 1 column with Start Date for Fiscal year & week 2nd column is end date for fiscal year & week I want it to return 3rd column where i have FYYRWK This is all housed in a separate smartsheet. Ive…
Hi, Can we make a logical condition with forms? For example, I have the first selection for Gender and if someone select "male" or "female", it will show different forms for each selection.
Hi, I'm quite new to workflow and I'm trying to achieve the following: A document need to be signed by 2 signatories, signatory 1 received an automated update request from workflow 1 which works well.…
I have a master row that I would like to track the year's progress. In my image, I would like the [Status] ball to stay Green if "YES" and if blank in [Count] cells January - December. Want it to turn…
Hello, I am trying to troubleshoot a formula to achieve the following outcome. Outcome: Count the TOTAL number of rows in which [Assigned To (In-House Designer)] is "Danielle Morrison" AND the [Reques…
Hi, Is it possible to creare forms with workflow e.g if I click "fruits" I will se options "Apples, Oranges..." If I click "Veg" I will se options "Tomato, Onion..." I would like to create Sales tool …
Hi, Is there any way i can create a form so that, if a certain field is selected from a dropdown menu another field then appears needing to be filled out? Any clarification needed feel free to let me …
I have a task that spans a weekend. It does the correct calculation for the correct number of working days, but in the calendar it's a bit misleading for our team. It makes it appear as if the task is…
Hi there, Is there a way to create a new custom column type? For example, I'd like to create a column type "Department" which would be a drop-down that would be populated with a managed list of offici…
Hello, Need help, I want to identify which questions have the highest "No" respond. On column "MAX - NO" will appear the name of the questions that have the highest No respond. Currently, I can identi…
