-
Search for a row / text in a cell in a Report
Good morning We use Reports to enable administrators to enter details to certain rows to sheets without having to trawl through the hundreds of columns in the sheet. There are however hundreds of rows in the report each relating to a different client, and each waiting for info to be inputted. Is there a way of searching a…
-
Finite Dropdrown values?
Hello I'm was wondering, if it's possible to make a list of dropdown values available. But every time one value is used, it's removed from the list of possible options for the following row. Number 1, 2, 3, 4, 5... If I then use number 1, it is not possible to select 1 for the next row. If I then use the number 4, it is…
-
How to stop text in RTW from moving?
I am creating a dashboard for a monthly project status report, and have used Rich Text Widgets for Headers. For some reason it has space above the words (have selected to not use title), so when I go onto the sheet, it looks like this: Once I go into edit mode I can scroll up on the box so that the whole phrase is visible,…
-
Scheduling 30-60 task annual projects with just 200 whole working days per year
I want to develop a template sheet that I can use to easily schedule out 30 to 60 different 30 min subtasks evenly over 200 specific available work days each year. I started out trying to set up a gantt view row with "200d" working day duration then removing sat/sun, and inputting 62 other Non-working days in gantt view…
-
Using info from "request an update" later in the same workflow
Hello. I am having some trouble with a workflow. The trigger is a new sheet row and the first block is an approval. This part works fine. If approved, the following block is an update request which asks someone for an email address. That email address is inserted into a contact list column on the sheet. This part works…
-
Generate Documents: Formatting Suggestions?
I've been struggling with my PDF for document generation. I have created the layout in Excel, exported to PDF, used the prepare tool to create fillable fields, and imported the PDF into Smartsheet. It works, however if I have to make changes to the form layout/structure, I have to manually re-map about 1/3 of the fields…
-
Fillable PDF boxes are removed when I replace PDF
Hello, Its not that big of an issue but it is very annoying and time consuming. I have a fillable PDF and had all the boxes on the side I dragged and dropped into the PDF and saved it. It works just fine but I had to make some changes and when I went to the same mapping and went to the settings to replace the PDF half of…
-
Form entry did not populate sheet
I have a form that I have been using with my team for over a year now successfully and today a user submitted an entry using the form, however when reviewing the sheet, the information feeds to no line-item entry was there. The user did get an email notification with their submission confirming that the entry was…
-
KPIs/OKRs Template
Hello, Do you have a suggestion of a template to track business performance KPIs? This is for 20 depts across multiple locations so that KPIs will be shared for the same dept across multiple locations. Thanks,
-
Why do inserted rows (or cells) come with their own background color?
When I insert a new row to one of my sheets it automatically comes with a gray background. All other rows have a white background. The only conditional formatting assigned to the sheet is to gray out the font once a date in a date-column is in the past. In another sheet something similar happens: Some cells in the inserted…
