-
=iferror issue
Hi I have a formula as follows in a cell, however when there is no data to display I do not want the message Invalid Data Type formula is =NETDAYS([TESTING1]@row, TODAY()) I have tryed =iferror(NETDAYS([TESTING1]@row, TODAY()) but had no luck Hoping someone can advise the fix and what went wrong please
-
Avg Collect Formula Error
I am attempting to create a formula for a dashboard that pulls data from a sheet and needs to reference the amount of days from Approved to contacted for a specific Agent and by Month. I tried to use several formulas starting with the following: This pulls back all 0's. I also tried this formula and got the error #Divide…
-
Automate Weekly Copy/Paste of Hierarchy
I have a weekly tracking sheet that I update each week by doing the following: 1) Copy/Paste the current week's hierarchy (lines 546-561 in screenshot) to the last row of the sheet, 2) Update the week column, and 3) Clear some of the data for the new week. While this doesn't take a long time for one sheet, I do a similar…
-
Duplicate Formula
I have a Smartsheet which is fed from a form an Intake team is using to gather prospect information and we are having issues with duplicate entries. The sheet/form has a field for prospect first name and another for prospect last name which we would like to check for duplicate entries of. I created a column combining both…
-
Create Column Formula on Duration column
For a duration column being calculated as the difference between two date/time fields, the Create Column Formula option was unavailable. (Converting the column to a text/number column allowed application of the column formula, which then persisted when converting the column back to a Duration column, so the underlying…
-
Average value between two dates.
Hi, I have generated a report from different project sheets. I have a column (C) which has dates when a particular task is completed. Column D calculates the time taken to complete that task (Turn Around Time - TAT). I want to calculate the average TAT taken to complete a task in the month of Feb. I am not able to put two…
-
AI Text and Summaries Column Formula
Hey All, I submitted this product enhancement request through a feedback request a while back but I think this idea has a lot of merit and would really benefit the community as a whole. If you are like me, I'm sure you are all using and loving the AI feature! One thing that has been cumbersome about it has been that in…
-
Index Match Across Multiple Sheets
Hello Smartsheet Community! I have reviewed a few similar posts on this subject, but have further questions ... Examples shown on other discussion threads, show to use stacked IFERRORs, and repeated Index/Match in the formula to look at multiple sheets, however I am not able to get this to work. When you're stacking…
-
copying rows to RAID log
Howdy, partners - I'm trying to use the copy row automation to copy tasks into a RAID log when a user identifies a risk or issue in our Project Plan. Our plan has a few sets of parent rows, and I'm finding the copy automation is not bringing just the direct parent, but the entire sheet into the RAID log. This is obviously…
-
How to create a formula to pull the first part of an order number into an adjacent column
Hello! I am struggling to create a formula to pull the first part of an order number (our internal agency numbers) into a separate column so I can see how much each agent sends in each month. Screenshot of the order number below:
