-
Create Formula in Sheet Summary field to pull only Month from another Sheet Summary Date Field
I have a date field for projected go live date for projects in my Sheet Summary. I would like to add another field with a formula that will display only the Month Name in another field so that when I run the Sheet Summary report I can summarize projects going live by month. I would appreciate any guidance!! Thank you!
-
How to number the duplicate by Sequence or Order?
Hello there! I need help on finding duplicate values to my table and then put them in sequence or Order. Thanks in advance.
-
How to Get "Responsible Email"
Hello @Everyone, I'm new here in the community, hoping to get support from someone who have work on the same use case I have below. Use Case: I have 2 tables, 1st table (Stakeholder Database) with column names Name and Email. 2nd table, (Sender Tool), with column names Responsible Name and Responsible Email. I want to seek…
-
If statement based on values in two different cells
Hello - I have 3 cells in my sheet, "Assigned To" "Date Completed" "Status" I need a formula that says if "Assigned To" is any text, then then "Status" would = "Assigned", and once someone puts a date in "Date Completed", then the status would change to "Complete". Any help is appreciated!
-
Filters and Formulas
Hi Smartsheet, can you please consider adding a click box that reads "Convert to Sheet Summary" in your filters so that we don't have to recreate a formula as a filter to generate a report. In addition to "Include parent row" a click box that reads "Generate a Summary Formula" would be nice. BTW your AI is super nice.…
-
Lead Time calculation
Hi I am trying to create a lead time calculation to see when a request for work was submitted vs what the due date is. Purpose to report on lead time to promote better planning. I had this working when I had a request date in my form. However I subsequently changed that field to a "created date" system field to auto…
-
How to use IF statement formula
Hi Smartsheet Community, I currently need help in generating a formula where in I have multiple countries in a dropdown column and I need to identify which region they are from. Ex: A form collects data from users and they input their country. In the back end (grid), I need to collate all entries per region. So Country…
-
Formulas to set up KPI's for shipments requests
Hi, I need some help with forumals which is not my strength, thanks in advance. What I need is to set up KPI’s measure for my shipments. There are 3 parties involved that need to complete their own step. Once each step is completed by each party (regulatory, WHS and Logistics). it will record a date highlighted in the…
-
Unparsable IF( & Gantt
I'm trying to make my Gantt display carry my current projects out with a hidden "completion date" row and IF= code, but it won't work. If my unhidden completion date cell is blank, I want it to autofill todays date so my gantt will show current projects, but if my viewable completion cell has a date in it, I want it to…
-
Is there a formula I can use to count how many points someone has received?
We are using smartsheet for submissions for a point-based program we are running. When someone submits an item to the smartsheet through a form, they are awarded between 1-6 points based on what the item is that they submitted. Is there a formula I can use to count how many points someone has received so far, based on the…
