-
Set default text for a given cell
I am creating a template and would like certain cells to give an example or show what type of information should be entered. The default text should be in that cell always unless other text is entered in. If the newly entered text is deleted, the default text would show up again. In doing some research, this type of field…
-
Track Daily Variance Between Forecast to Actuals Across Multiple Cells and Sheets into Master View
Hello, I am desperate for some guidance on the best way to handle my situation. First, I have 2 sheets that I'm attempting to provide an executive view for: * First sheet is a forecast that indicates the number of people we should be training in any product line. The individual product lines are listed in the primary…
-
Cell linking
What am I doing wrong? I am linking cells from one sheet to another. When I do so I select two cells and then link them to two cells in another sheet. However, only the first cell has a link not the adjacent one? Also when I delete the link and go to try again the deleted link still appears in the source sheet.
-
Problem in taking the weekof as Wednesday
I want Wednesday as the weekof based on the date for e.g. If cell A has date of 25th Nov, the weekof in cell B for that date should be 20th Nov If cell A has date of 27th Nov, the weekof in cell B for that should be 27th Nov If cell A has date of 26th Nov, the weekof in cell B for that should be 20th Nov What would be the…
-
Can Smartsheet get data from custom HTML forms on a website?
Hello, If I'm building a website, can I create a custom HTML form and get the data into Smartsheet somehow? Smartsheet's native forms don't have the capabilities that I need (conditional logic) and I would like to make my forms a bit prettier. Thanks in advance!
-
What happens when I reach my 5000th row?
May I know if there will be any alert when a sheet is reaching it's 5000th row? My team is working on my sheet as free collaborators, can I be alerted when the sheet is reaching the maximum capacity? Thanks.
-
Conditional Formatting doesn`t apply to Report
Hi there, I was playing arround with the conditional formatting and stumbled across a problem. I have some rules, based off the "Modified" column. When those rules are used on a custom column, it works just fine. If the rule is used on a system column (Modified in my case) it doesnt seem to apply the colours in the report.…
-
Getting sheetnames to appear in certain order in a report
Hi there, Can anyone help with how to configure sheet name so it appears in a particular order when shown in a report? I have used numbers (1. Red, 2. Yellow....) and letters (A. Red, B. Yellow....) but both approaches do not work consistently. A-G seems to work but the following letters dont (see image) . The numbers seem…
-
Report and Calendar View
I created a report from a sheet. The report contains only a few columns. This report is intended to be mostly used for calendar view. The items we want viewable in the calendar are the same items contained in the report -- not the main sheet. In calendar view, if you click on a scheduled item, all the details from the main…
-
A keyboard shortcut to delete the selected row(s)?
I can't find how to delete the selected row using keyboard. I can only do that using mouse. It's very inconvenient - in MS Project I select entire row using shift+space and press Delete to actually delete it. In Smartsheet when I do that - it just clears the row but keeps it there. It's very inconvenient to have to switch…