- Permutation Generator
嘿——我不能得分nough time at the formulas booth this week to pick someone's brain on this one. I am looking to re-create an Excel tool that I use to create all permutations from a two column matrix, for example, if I have two columns called SIZE and SHAPE, the next column should be a column formula…
- IF and ISDATE Formula
I want to calculate NETDAYS from Submission Date to Todays Date, or to Comments Log Received Date I have this formula that works. =IFERROR(IF([Comments Log Received]@row = "", NETDAYS([Date Submitted to SJTA]@row, TODAY()), NETDAYS([Date Submitted to SJTA]@row, [Comments Log Received]@row)), "") However, I need to expand…
- Why is this #incorrect argument set
=SUMIF([Task Status]:[Task Status], "Completed", [Contact(s)]:[Contact(s)], " ricky torres ") I'm trying to show the completed tasks in the contacts column, and specifically for the contacts individually.
- Formula - Helper Column Flag if Duplicate
Is there a formula I can use in a helper column to flag an entry if a duplicate already exist? We are going to share add forms with 100+ people to enter information about their employees. The last time we did this many of them entered duplicate employees causing a lot of chaos. The goal is to send out alerts/notifications…
- Date Formulas
Hello Everyone, I'm new to the smartsheet community, but have been using smartsheet at a basic level for a few years now, and I am looking for some help. I have a form that collects information for me. Each time the form is completed and submitted it creates a new row in my sheet. In my sheet, I have a column called an…
- Trying to return the date if a certain row task is marked Complete
After spending some time learning about a bunch of different things in Smartsheet that aren't helping with my problem, I thought I should just ask my question. I am missing something small I think. I have tasks in my projects that need to be completed after it is implemented. I want to capture the "Execution Complete" task…
- I need help with a formula or direction if a formula isn't the best way to go
In my sheet I have 4 different dates , requested, procurement, legal and council, and I want the status to change when each date is filled. So if status has a date I want the one quarter symbol, procurement the half symbol, legal 3/4 symbol and council full. can someone help?
- Column has a formula, need answer as a multiplier
C Value column is a formula =IF(ISBLANK([Solution #31 Correction Factor]@row), "", IF([Solution #31 Correction Factor]@row = 9.5, "1.05", IF([Solution #31 Correction Factor]@row = 10, "1", IF([Solution #31 Correction Factor]@row = 10.5, "0.95", IF([Solution #31 Correction Factor]@row = 11, "0.91", IF([Solution #31…
- Parent Flagged if Children Flagged
Hi all. I have a task list that consist of multiple parent rows with Children I have modifided so that if a task is delayed or dates are not added in the task will get a flag. What i would like is to have if one or more of the Cildren Rows are Flagged the parent row will be flagged. but cant figure it out. Ivé tried with…
- Could someone help me with this formula?
We are asking our managers to use SmartSheet to enter information about their employees (via the add form). Be are requiring them to enter the employee ID which has to be 9 digits, but many times they don't enter all the numbers. I read about helper columns to check whether or not the format is accurate and then send an…