-
Copy a new text entry to another sheet without duplication
Hi Smartsheet Community, Dummy scenario is: I am using a smartsheet form to survey people on what their favourite colour is? Since any responder can enter any colour or shade, I don't have the colours pre-defined. The survey captures the responses into a database, from which I will do my analysis and dashboard. How can I…
-
Copy row for all columns before "Yes" Column
I am working on a project, and there will be MANY times that there will be multiple requests. This column is a dropdown with 2 options, "Yes" or "No". If the response is "Yes" I would like the data from that row, all columns PRIOR to that column copied to the next row. If the dropdown selection is "No" nothing is done.…
-
Project Status Formula to return blank
Hello, I am looking to return a blank cell in my parent lines in my project status column if there is no project status listed. The formula I have right now is: =IF(COUNTIF(CHILDREN(), "Complete") = COUNT(CHILDREN()), "Complete", IF(COUNTIF(CHILDREN(), "Not Started") = COUNT(CHILDREN()), "Not Started",…
-
Counting the number of items due in the next six months from today's date
Hi, I am struggling to find a formula that can count the number of items (each row represents a task/project) that are due in the next six months from TODAY (the date of viewing). At the moment the below formula is incorrect ... =COUNTIF([Target Closure Date]:[Target Closure Date], IFERROR(MONTH(@cell), TODAY(MONTH(+6))))…
-
Suming Amounts if numbers match
=SUMIFS([Revenue Projection]25:[Revenue Projection]36, [Month - Count]25:[Month - Count]36, >=[Month - Count]7) I want to say sum revenue amounts if the months are greater than the current month (8). The problem I see is its only adding months 8 & 9 and not 10-12.
-
Matching values between column and row between sheets and returning corresponding value
First post. Struggling with this one. On Sheet 1, I want to compare the week number from a column on sheet 1, to the week number in a row (row1) on sheet 2 and then return the value, in this case a symbol from row 4 on sheet 2 . Sheet1 - Sheet 2 - Am only showing part of week number range. But in this case am I after - if…
-
Duplicate Values causing multiple emails being sent with the same info
So I have a sheet that is essentially tracking missed attendances. And we want to know when a miss happens each time. I have it set up currently to check for duplicates and then a box gets check for each miss up to 3. Then I have a workflow to notify different people based on the number of miss it was. My issue is that…
-
(SmartSheet newbie) Filter and Count across Columns
Hello, I am very new to SS (a day into using it) and I'm not even quite sure how to ask this question. I am trying to create a dashboard to see the total number of different types of positions in my company, with intersecting filters. I have a master sheet with a column for the type of position (Contractor, FTE, etc) and a…
-
RAID Metrics
Hello! I am hoping to get a little guidance. I am a little rusty on formulas and I have been trying to determine the count of "Open" items on our RAID log. We have Risk, Action, Issue and Decision that is a drop down option under our "RAID Type." Our "Status" column has a drop down option of Open, Closed and Canceled. Our…
-
Is there a way to capture a date in cell history?
We use and install date and those dates change as we go back to jobs. I want to record that first date in another column. is this possible?