-
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…
-
Sheet Summary Limit
Is there a hard limit to the number of fields we can add into the new Sheet Summary page?
-
Index / Match Multiple columns from another sheet
I tried to use index/match to reference multiple columns from a resource sheet. I can't seem to get the formula correct. My table (resource) has a list of teams with start times, parking information, notes, etc. The table includes all the team information. When I add a name to the new sheet, I assign that name to a team.…
-
Return Most Recent Date and Other Column Value or Only Flow Most Recent Entry into Sheet per Account
I need to be able to return the most recent value for the Created Date column and the corresponding Discussed column text. Currently, I am using an IF, COUNT, MAX, CHILDREN formula that I found on the community to return a MAX date within a grouping of rows but I can't figure out how to also return the Discussed value that…
-
How to handle a very long list of (multiple select) choices in a form
I am new to Smartsheet and using it to replace old InfoPath forms. One thing I cannot find an elegant solution for is expanding fields/sections. Basically, I want to send an instructor a form that asks which courses they would like to teach next semester. There are hundreds of courses. I will eventually want to use this to…