-
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…
-
IF Error Function help
Hello, Request your help to figure out what I may be doing wrong here. Please see the screen shot below The formula is on the % complete column below. I want the #DIVIDE BY ZERO to be a NULL value and was trying to use the formula below . The formula gets the desired result but I want the I want the #DIVIDE BY ZERO to be a…
-
Automatically Organizing Rows into Hierarchy
Hello Smartsheet Community, I am yet another formula-deficient SS user. Looking for insight on a formula or function I can set up, as I asked the AI formula developer tool to create a formula for this request and it stated, "Smartsheet formulas cannot be used to automatically organize rows into hierarchy". I have created a…