-
Formula from hell
I have ranges of data in multiple forms. There is criteria that must match from each to be summed on a third sheet. The criteria are GL Accounts and a month Code. One of the month codes is listed as 12 Month. The intent of that code is to signify that the cost in one of the columns should be spread across 12 months. So I…
-
Sorting Issues
I'm still looking into this but has anyone had any issues with the sorting feature? We have one sheet that 17 people are constantly working in a day. (All Editors and 2 Admins if that makes any difference) This morning we SORTED several rows and HOURS later someone who had the sheet open, saved their data and INSTANTLY ALL…
-
Return entire row when value is matched in another sheet
I have a source sheet with hundreds of rows of entries. One of the columns is named Property. There are many different values under this column. I have a destination sheet for each one of these possible values (in this case, a property). What I would like is to have have any rows in the source sheet which match a specific…
-
Back calculation of dates in Gantt View
Hi there, I'm building a schedule in Gantt View by back calculating from an end date. The issue I have (refer attached screenshot) is that I require the finish of the task at row 353 to be the earlier of the start of row 355 or 2 x weeks prior to the start of row 32. When I put in what I understand these predecessor…
-
Transform time in minutes
Our Smartsheet has been build with time entered that way 2h00 0h15 0h15 1h00 3h00 2h00 1h00 0h15 0h15 3h00 0h30 18h00 I want to transform that value automatically in minutes (120 / 15 / 15 / 60 / 180 / 120 etc) Any idea on how to do it in smartsheet? thanks
-
Completed Row Drops To Bottom
Hi everyone, While at Engage18, I heard there would be a way to have a row drop to the bottom of the sheet, once completed. Does anyone know if it's at all possible right now, or is this something they are still working on?
-
MAXIFs Alternative?
I have a google form that updates the prices of materials. On google sheets to display the most updated price of the material I have a Newest Entry Column =MAXIFS(Timestamp:range, Material cell) then in the material price columns I have an Index/Match formula to display the most recent entry for that material. I would like…
-
Date Calculation
I have 3 columns. 1 column is the date that the time begins, the 2nd is a factor that is either 1.5, 3 or 5. It is always one of these three numbers. The 3rd column is for the end date that is auto-calculated by taking the date in column 1 and multiplying it be the factor selected in column 2. How do I do that? I am really…
-
Move Project with Predecessors
I need help moving a project that has predecessors. This is being used for a production facility to track the status of our projects. However, I have run into a problem when needing to move a project in the order of production. The predecessors are not moving with the project change. -I need the "Design" process of the…
-
Smartsheet connection with Alteryx workflow
Hi, Someone facing an issue to connect data from Smartsheet into workflow in Alteryx? I have an Alteryx with data connected from Smartsheet that always worked well, but last friday the alteryx wont able to connect with Smartsheet, the message in Alteryx is "No valid Fileds were selected. This connection between Alteryx and…
