-
No "reference another sheet" prompt
Hi All, I'm a noob, trying to do a basic vlookup (or match, don't care), but when I start the formula, there is no "Reference another sheet" prompt, as I see in every single help video. I've tried directly typing in the name of the sheet/table, but it's not producing. =VLOOKUP([Contract Name]@row ,{List of…
-
Smartsheet - Down to the Basics Cheat Sheet
Hello fellow community members! When I first started using Smartsheet, I struggled—a lot. Even the most basic tasks felt overwhelming. As someone who learns best independently, I started creating a personal cheat sheet to keep track of all the key functions, tips, and tricks I picked up along the way. Over time, it became…
-
Rolling updates - can I automate data selection for dashboard?
I have a set of dashboards used to show the same data every reporting period. Reporting periods are 100 days long. They are identified as Start Month - End Month (x00 days). Is there a way I can automate data selection for my dashboards so that it picks the current reporting period ? Data feeding into the dashboard comes…
-
Restore previous version
Hi all - a poorly structured data shuttle update has deleted all my sheet data. I'm on hold to support but does anyone know how to restore a previous version of a sheet?
-
Override an Auto Number in One Cell
Is there a way to override an auto number in one cell, but leave the column as an auto number? Thanks,
-
Export to PDF Selected Rows
Hey all, Hoping this is an easy fix. I can't seem to print/export selected rows, only the entire sheet. I'm trying to document employees scorecards in one sheet for supervisors then have them export the individual employees row to review with them on a monthly basis but it won't let me do the selected rows button. Any…
-
IF level@row = X, Display short version of dashboard link, else calculation
Hello Community, I have a series of columns that are summarising the output of complex projects. I would like to be able to have a "Link to Dashboard" at the top of a column that is a column formula. The link would provide the end user with instant access to more detail if required. Ideally if anyone has a solution, the…
-
How can I get the subtask to populate a report that shows all the task assigned to a certain individ
I see that the task itself (Semiconductor certificates campaign) is populating the report, but how can I get the subtask to populate the report as well?
-
leading with "0" but the cell must be a number
I am trying to formulate a row so that it always contains three numbers, starting with 0. This column has to be a number and not a text as I need to sum the total in a report. Currently, I am only able to make sure there are three digits by making it a "text" cell but when I go to summarize the total in a report its not…
-
Grouping and summarizing in reports
Is there a way to have two separate groups in reports? Not one "then" another, but two separate ones. I have columns with checkboxes, and I want to group them separately so we can see which rows have "Answered?" checked and which have "Follow-up?" checked, but we don't want it to group in this way because we will have some…
-
Formula to Pull Just Words or $ Amounts into a Report
Not sure if this is possible - If there is a cell that has words and then a dollar amount, is there a formula that can be used to pull only the dollar amount into a report and then on the opposite side be able to pull the first part and not the $ amount? Ex: 11111 - Test Item - $100 The format for the example could…
-
How can I automate a Dropdown list, so every value added to the column becomes an option?
Hello community, I'm new to Smartsheet and I'm struggling to find out how I can make every value added to my column to become automatically a option in the form dropdown list. Anyone knows how I can do that? Thanks
-
Is there a way to limit the number of characters in a particular column?
We are gathering information related to tickets though a smartsheet form. We have a particular column (primary column) to record the ticket number which is alpha numeric characters. The ticket # is always 11 characters, since the smartsheet is limited to managers and the form is only used by agents we want to prevent…
-
Time Spent /Formula
Hello, I want to calculate the total time spent by each user to then create a graph. I tried a formula but it does not work. Can you help?
-
Split a long text into lines when a document is generated
Hi all, I´m dealing with a challenge when a long text in a cell is mapped to a "text box" in a generated PDF. Despite there is space to separate in lines, the content of the cell appears in one single line, impacting the font size. Is it possible to customize that? thanks and Regards
-
Can you attach a video to row?
I am not finding anything on what type of files can be attched. Specifically video files. I know I am probably not looking in the right spot for the answer. thanks
-
Logic not working properly.
I'm trying to add 5 different logics. If question number 2 "does not contain" 24, 23, 22, 21 or 20 I want the error box to come up. I enter in the first logic step and it works, once I start adding more it stops working properly. Now, when ANY number is entered for question 2 the error box appears. What am I doing wrong?…
-
Accessibility
Hi All, Would love to know from all you experts if there are workarounds to this problem I have. We currently have a checklist I have created - for project/work handover. The checklist is to be shared with our client from different org as well. That was easy. However, our client now requests that they should be able to…
-
task cut
Hi everyone, I'm trying RM and I have this situation: Task1 has been programmed for User. While executing task 1, an urgent task (2) has been assigned to User. So, User needs to stop Task 1 and suspend it for a period. Must give priority to urgent task (2) How can I handle this in RM? Is it possible to cut the activity? It…
-
Basic Question: How Do I Add ROWS to show in a Dashboard
I feel dumb, but I can't figure out how to add up the total rows and get them to appear as a metric in a Dashboard. It's a complaint ticketing system, as a new complaint comes in it adds a row. As the rows add up I want that number (row total) to add up in the dashboard, as the ticket is cleared I want it removed. How do I…