-
Display partial content from a cell
Hello! I am attempting to show part of one cell in another cell. This is the formula I tried but I am getting inconsistent results. I am trying to just show everything after the - in the Author ID column. Where am I going wrong? =IFERROR(RIGHT(Contributor@row, FIND("-", Contributor@row) - 1), "")
-
Report Filtering
Hi Can we create and use "on the fly" filters in smartsheet reports (just as we do in Google Data Studio). For example, the current view of my report is showing me all the data of this year; but while viewing this report I might wish to view only last 30-day data, which was posted by a specific person. So can we accomplish…
-
Dynamic Filtering based on a few columns
I'm creating an onboarding template that a hiring manager would copy each time they hire someone to serve as a checklist of what needs to be done. I'd like the manager to be able to select a few parameters - FTE or Contingent, which location, which team, alternate instructions if Covid 19 applies - and have the sheet…
-
Feature request Automation: using an automation rule to move or copy only some data, not entire rows
Can automation function to MOVE or COPY data based upon some conditional change allow a use to select what fields get MOVED or COPIED and map to a specific column name? On my first SmartSheet, I might have 20 columns, when a status changes and an automation rule is triggered, I only want 5 of those field to be copied or…
-
vlookup using information in Gantt chart
multiple layers of questions here. 1) vlookup is unable to locate the cell data. the data for the comparison looks the same, no odd spacing or misspelling, however, they are sub tasks in the gantt chart. I've tried both true and false for the last term in the vlookup. 2) permissions - so I'm using info from a internal only…
-
How to add primary column to report
I am unable to click the 'columns' button at the top right when creating a report and add the primary column. Down below that in the filtered section it will let me add it, but not data shows up. It is a free text field where the guys on the job type in their notes from that day's work. I would like it to report out so…
-
Does this function exist: highlight 10 rows, click Link Tasks, and all predecessors are filled in
Finally using this for a large project 350 line and I read in your help ----->>> In the Predecessor column, type the row number for the item that must occur before the item you’re working with. This is what I do in Excel. Am I missing something in SS where there is this function, like in MS Project where I can link and…
-
Pasting from excel into primary column in smartsheets
this is probably really obvious but why when I manually enter a value into a new row in the primary column all the formulas are replicated to that new row, but if a paste a value in from excel the formulas don't get replicated? many thanks in advance Andy C
-
Learn more about collaborative work management solutions at ENGAGE ‘20
We’re excited to have you join us for ENGAGE ‘20 this year- our all virtual event on October 1! We’re offering several sessions around building effective collaborative work management solutions in Smartsheet and we want to hear from you! How are you using Smartsheet to collaborate and get work done? Leave us comments…
-
Edit field spacing on form
I would like to edit the form. Change spacing between fields, have fields next to one another.