-
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?…