-
Formula returning "2" suddenly, other cells, same formula not returning the "2"
Please see attached, formula has worked for a long time an typically pulls the data from another sheet as intended. I looked today and suddenly I have a "2" in a lot of the empty fields, and cannot figure out why. The formula I am using: =IFERROR(IFERROR(INDEX({PERFECTION YARD CHECK RO #}, MATCH(VIN@row , {PERFECTION YARD…
-
In Control Center: Link Assigned to, to Project Team on Intake
I have Control Center. We are set up to where the project team is not entered when a new project is created. The column is there, but the requestor doesn't necessarily know how the project team is. As we build out the project plan, I would like to have everyone that is "Assigned To" a task, auto-populate the Project Team…
-
Manual Update Request on Table/Board View
One feature that is yet to be implemented on the new Table and Board view is the ability to send manual Update Requests. This one feature is delaying my teams transition to the new views. Hopefully this feature is on the Roadmap and will be implemented soon.
-
Smartsheet Specialist - Available for work
Hi all, My contract is coming to an end soon and I am looking for my next opportunity. I have 2+ years experience in designing and building complex solutions for a live events organisation. I love figuring out how to balance what the organisation needs, what the platform can actually do, and what will work for the people…
-
Control Center Find/Replace formula not working
I am trying to do a global update within our Blueprint on just one sheet in the summary section. All sheets have the same column name and the same row. We are trying to change the last "Description$8" to be "Description$12." When I look at the test sheet, it still has the "Description$8."
-
Is anyone using Smartsheet as their CRM?
We are looking to convert to Smartsheet as a CRM, but wondered if anyone has done this and the steps they took to develop their system. Also, transferring the information from the current CRM onto Smartsheet, any tips for how you did this, manually or via CSV file? Need some help.
-
Unable to find my registered email address while submitting a bug in Dynamic View
Hi, I am unable to find my email address under Adhoc Bug reporting. So due to this i am unable to submit bug. Could you pls help me in submitting bug.
-
Comments created after long set of empty pages
One of my team member is facing a repititive bug while entering comments on Smartsheet tracker. He has full permission on the tracker and doesnt have any internet or version issues. He is faccing this Smartsheet bug for some time where the comments are created after long set of empty pages and its hard to know how many…
-
Formulas reading from ROW above.
Hello Community, Especially you @Paul Newcome the Formula Guru! I cant resolve this problem in the last 2 columns of this sheet. As you can see the Expected Cumulative Progress % is adding the Progress Weight + the value of itself from the row above…. any idea how to make this dynamic? Whenever new row is added / removed…
-
How to get an average of multiple symbols (harvey balls) on a single row?
Hi, I have a form that once completed populates a sheet. The form has about 100 items. The idea is that 100 items represent 5 categories. For each individual that completes the form I need to provide an average from the 100 responses that correlate to each category. I have the columns next to each so I can use the "range"…