-
Locking a Formula in a Column
I created a formula in a column that I do not want people to be able to change, but to still function as people add new information in the rows. By locking the column, will the formula still work (the cell will still populat/update) when the reference cell in the row is updated?
-
rollup formulas
I have personnel sending out emails. I want to track how many total emails each person has sent in a given city they put a checkbox after each email has sent. I would like a formula that would total the checked boxes from each person. is that a countif? countifs? thanks, SGF
-
CountIF Formula issue
Greetings, I'm currently attempting to create a CountIF function that counts the number of Ungroomed Stories that start within the next 30 days. My formula is the following: =COUNTIFS([Issue Type]:[Issue Type], "Story", Labels:Labels, ISBLANK(@cell), Status:Status, "To Do", [Target Start Date]:[Target Start Date],…
-
How to Create Formula to return Fiscal Week
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 tried a few different articles on smartsheet, but cant seem to get one where i want it to be = or Greater than & less than…
-
Logical Condition with forms
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.
-
Update request form after completion/submit not triggering workflow
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 want workflow 2 to automatically request an update from signatory 2 when signatory 1 has completed his task. I tried…
-
Excluding Blank Cells in Formula
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 Red, if there is a "NO" in any [Count] cell. If all [Count] cells are blank January - December then "Blue" YES followed by…
-
COUNTIFS Formula For Total Number Of Assigned Projects To Individual
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 [Request On Hold] checkbox in UNCHECKED. Background Information: The Assigned To (In-House Designer) column type is a Contact List…
-
Forms with Workflow
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 for my team so they can go step by step with sales process without missing steps. (Maybe you no other tools for doing that).…
-
Conditional Sections of a form
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 know :) Cheers
