-
Feature Request: We need advanced functions to connect and control multiple sheets
I am a project manager at a construction company so we use Smartsheets pretty heavily for everything from vehicle mileage reporting to project forecasting. The single biggest improvement that I would like to be done for Smartsheets is for greater links between multiple sheets. We are thinking about migrating to Sage 100, a…
-
Equipment Check-out...
Has anyone implemented a sheet for use as an equipment check-out form? That is a web form that is filled out by the user which allows them to select from a database of available equipment and indicate the length of use in days? I think I could do that with a column dropdown list populated with the items that are available.…
-
Please help with an a SUMIF formula
I have a spread sheet with a column (with a formula) that counts how many days it took for each project to get from one department to the next. I am trying to figure out a formula to add all those days together but just from a specific month in 2018... I will eventually have to do this for each month for the next couple…
-
formulas in update requests
Hi, i'd like to use smartsheet for end of year bonuses. I ideally would like to send an update request to managers with the info below. I can lock all cells so that the only one they can update would be column C - but is there a way on either update request or something where if they change the drop down of column C a new…
-
How to make a Status row function like a Status Column
Hello! Is it possible to apply the properties of a column to a row? I want to be able to update the status of each column in a single row. I'm not able to identify where and how to do this; please see my attached screenshot. Currently, I have a column titled Status (circled in the screenshot). I essentially just want this…
-
Custom Column View Templates
Is it possible to save custom views for columns? I would like to be able to show, hide, sort, and order columns via a template. I am able to filter based on specific conditions but I also need to be able to view the data a specific way.
-
Cancel reoccurring update requests when complete (or 100%)
Hi All, I might be missing something, but I want my reoccurring update requests to automatically stop sending when the activity they relate too reaches completion. Anybody know how to do this? Appreciate any guidance you can give me. Mike
-
Base rule off of 2 columns
I'm looking for a way to create a rule that would be: If Column "Status" says Funded, and Column "Fee" is blank, make the row Yellow Is there a way to do this? I can't seem to figure out how to get 2 columns on there to create the rule Thanks!
-
Blocking Actions on a Spreadsheet
We use Smartsheet for our work holiday/vacation planner. We don't want holiday overlaps so I would like to make it impossible for 2 employees to select the same dates. Is there a way to block actions? Is this something that can be done? Thanks in advance!
-
Formatting doesn't work for copied cells
Good afternoon. Can anyone help me with the following issue? I have a workplan on a sheet, where I coloured lines, separating sections of the plan, in a grey. Afterwards I copied a formula to all of the cells in a specific column, while the whole column became white (i.e. it changed grey into white in some of the lines).…