-
Reporting: Linking two sheets on a common column
In reporting I have picked two sheets. They have a common primary column name. The columns do consolidate (i.e. there is only one column with this name). But...I have two rows for each, i.e. row 1 is from sheet 1 and row 2 is from sheet two (of course, row 3 is from sheet 1 and row 4 if from sheet 2). Is there anyway to…
-
[SOLVED]How to count the amount of children of a parent?
Greetings, and thank you in advance for helping a beginner at Smartsheet out. so thanks to the formel ="<PARENTNAME> [" + (COUNT(CHILDREN())) + "]" I managed to count the amount of children a parent has in the parent row. However now I would like to use that number(the amount of children) in a summary, but I just don't…
-
Conditional formatting for how overdue something is
Hi all I am trying to use conditional formatting to change the colour of the date cell for when the date cell is over a week ago, and then another color for when the date cell is over a month ago. I think I may be missing something! So in effect, the cell would be normal when under 7 days overdue, when 7 days overdue it…
-
Downloading multiple files shows wrong file timestamp (7 hours in the future)
Downloading a single attachment from Smartsheet shows the correct file timestamp. But, downloading multiple files shows the File Modified date of 7 hours in the FUTURE. Another time, it was 5 hours in the future. The attachments were PDF's. This is on a Win7 environment. The data itself looks fine (inside the documents).…
-
Viewing/Scrolling images
Viewing images as attachments is somewhat cumbersome at the moment. Currently, you have to click individual images/attachments to view them. A next button would be super cool. Is that anywhere on the horizon? I appreciate the help and feedback. Thanks, Preston
-
Asset Management Template
is there a template for asset managemen template, where you can check out and check in your asset?
-
Feature Request: Groups in the Alerts section
I have sheets that are used tracking that have multiple levels of 'subscriptions'. I like the power of user groups, and may want one group to have a subscription to the alerts, but not another group. Unfortunately, the groups function does not work in the notifications/alerts section. It only shows a complete list of ALL…
-
Is there a way to build a template containing multiple sheets
What I'm trying to do (maybe there is a better way) is to build a project template with contains the project sheet, a requirements sheet, and a budget sheet. When we "use" the template, it then creates all three sheets. Similar to the "Solutions" on the Smartsheet website. Thanks in advance for any help.
-
After linking cells between sheets, text disappears
Hi, I'm linking a cell between two sheets, and as soon as I create the link, the text in my cell disappears. The blue arrow indicating the linkage remains, but my text is gone. Any suggestions? Thank you!
-
Nested IF for a status column based on a date column
Hello, I have a list of employee certifications where the certification name is in one column, the certification expiration date is in another and the status if this the 3rd. I have a column called NETDAYS where I calculate the number of dates in between today's date and the expiration date. The formula I can currently…
