-
Input the date for a multi-select dropdown
Hi all-- I am trying to create an efficient way to track my samples as they move around to different facilities. Please see my screenshot for what I am working on. Ideally, I'd like to just have the check box as in the screenshot because it's easier and faster. Space on my SmartSheet is also a premium. Now, I'm aware that…
-
Populating cells in a column with data from cells from a different column on the same row
Hi, I'm currently trying to build a column where if the cells are blank, they are populated with the data in a cell on the same row but obviously in a different column. This sheet is populated by form entries and I'm trying to fill this column without making its field on the form mandatory. Thanks.
-
Return value if a cell in the same row has highest value in the column
I'm working on an email campaign and want to see which issue has the highest open rate. If a value in Column C has the highest value in the column, return the value of Column A in the same row. I'm stumped. Can anyone provide this formula? VLOOKUP seems like the obvious choice, but I don't know how to reference a MAX…
-
SUM IF with OR and CHILDREN
Hello, I am trying to add one additional condition to this statement below, but can't seem to figure it out. Here's what I have currently (which works): =IF($[Row Identifier - Budget]@row = "Parent", SUMIF(CHILDREN([Alt Cost Center]@row), "", CHILDREN()), "") And I'd like to add an additional option that says if [Alt…
-
Access for invited Team Members
When connected to my company's network, only particular team members can access Smartsheet. For those that cannot access it, neither the email invitation or direct login works. From the email invitation an error comes up that reads "This site can't be reached. The connection was reset". When attempting to access from the…
-
Report with image of attachments
Hi Everyone, Is there a way to create a report that shows the image of the attachments? We have a quality control sheet that new items get added through a form along with a picture. I would like to create a report that can show the picture next to the fields associated the punch list item. Another way would be to export…
-
% Complete Column
Anyone else having issues? I cannot update this column in any of my sheets. It just jumps to the next line of it you hit return it auto adds a full line.
-
How to populate a column in a sheet based on a column from another?
Beginner here. I want to populate a column with the names of people in a new sheet, with the data to be taken from a column in an existing sheet. In this sheet, the names are given in the column multiple times over since it reflects each of the accounts these people have. I'd like each individual name to only be included…
