-
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…
-
Moved data from one sheet to another sheet - now its not showing up
I just moved data from one sheet to go onto another sheet and now it’s completely gone and not showing up. I refreshed and went back into the sheet the information was suppose to be moved to but it’s nowhere to be found. I am trying not to panic.
-
NOt allowing me to add more rows
Good afternoon I am trying to get my smartsheet to 727 rows but it is stopping at 297? Very strange. Does anyone know why I cant add more rows?
-
Capturing Approval Dates
I didn't see a solution to this anywhere, but I was wondering if there is an easy way to capture the approval date and put that date in another cell. I'd like to use this as a predecessor to another task, and if the approval is late, the other dates adjust. I want approvers to easily see how their delaying approval of a…
-
Validate if the Hyperlinks in the cell are a valid URL's
Hi, i am wondering if there's a way to validate any External URL to check if it is a valid URL with a status 200. Any help is highly appreciated. Thanks
-
Status Report based on certain conditions, i.e. dates, status etc
Hi Smartsheet community, I'm trying to come up with a status report to display information on what has been done in our projects between certain dates. I would really appreciate your expertise and help!!! For example: Project A Status Report for the period 04/Nov/19 - 17/Nov/19 What I want to show is: 1. Completed…
-
Report shows dates from sheet summary but not text
I have created a sheet summary and copied same format to other sheets. A number of fields in the sheet summary contain linked data from the actual sheet using cell linking. This includes dates and text. When I created a Report (summary sheet) to draw from the three sheets, the dates show up in the report in the respective…