-
Line Item Transfer to Another Sheet using Formula's
I'm working on a project and am hoping for some advice from the community of experts! I have a sheet that serves as an ongoing list of projects and information about those projects - once a decision is made to either fund the project or deny the project, I'd like that line item to appear in another sheet. My main sheet…
-
Drop Down Menus
Hello, I have a drop-down menu with a few selections and I want the next cell over to have a text based on what is selected from the drop-down menu. Can this be done? So on cell B3 I selected 5, and I want the word Tom to populate on cell B4 based on that selection. Thank you!
-
Sight - sharing via email a PDF version
Is there a way to share the sight the same way we are able to share a regular sheet? sending it via email in PDF format at a certain frequency rate (monthly, weekly etc)? Thank you Luiz
-
Date Validation
I am able to limit date entry to only current month and greater but I need to allow an entry of last month date upto seven days of the current month. Ultimately I want to limit the date entry into a cell to only allow a past months date seven days after the current month. I would like to use Validation for this.
-
Can input from two different Forms be fed into One Sheet?
I understand that a form can add new rows and data into a sheet. But what if I want data from another form to be pulled in. For example, data on the names of an employee, start date, salary, etc. will be pulled from a New Employee form. But I then also want to pull in data from a Survey from their Manager on their…
-
Using COUNTIF or SUMIF to evaluate a date range
Hi, so I have a ColumnA that has random dates for the current year 2017. The column is formatted as a "Date" style column. My goal is to sum each date in this ColumnA by Month: Example: So to the right of each date, I want the sum of all dates that are in "January" that are in Column A. Thanks
-
Change Control Automation for I.T.
I would like to create and automatic a change control process for I.T. As the VP MIS I want workflow with control criterias build in based on the change requested. E.G. if its a level 1 or a critical system or downtime etc. It would come to me. E.g. if it's an update or level 2. I can go to my I.T. manager. Is that posible…
-
SUMIF from one or more reference sheets
Hello, As an example, In a cell, I am looking to count the total amount of "Completed" statuses that are in a specific column labeled "status" on one or more sheets and have it tied to a specific "Category" column. Would I use VLOOKUP alongside SUMIF? Attached give you an idea of the breakdown. Thanks,
-
Index and Match - Referencing a different sheet
Is it possible to do an Index and Match referencing another sheet? My formula works when I am using data on the same sheet but when I try to reference a different sheet it does not work.
-
Ruler - alignment tool
We are only 6 months into our Smartsheet journey and thus often tinkering and creating new reports, it would be really handy to have a ruler at the top in order to align fields/columns in reports. I have marked where a ruler could sit with highlighter yellow below. Does anyone else recognise the need or have an alternative…
