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