-
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).…
-
Can hidden field on web form designate parent-child row status automatically?
Our Smartsheet has a client name column along with a designator column that indicates what type of work we are doing (M, S, or C). We have a web form set up for each (M, S, or C) using the hidden field so that when an "M" form is submitted, conditional formatting tells it to bold and back fill the row. Is it possible to…
-
Automatic 'Text Wrap' Feature in Grid View
Hello and thank you in advance for your time! One of the sheets that I use prequently has text wrapped automatically in the grid view. This has only started the last couple of days so I imagine someone in the building has changed this by mistake. I have been tasked to change it back. However, I do not know what I'm doing…