-
View sheet comments in column in main sheet view
Hi - Is there any way to view comments like a chat window in a right hand column alongside a sheet? The comments in pop ups seem too hidden. Thanks
-
Edit row from report
In a sheet's card view there's a shortcut ('Enter') to open edit form for that row. There's no such shortcut or option in standard grid view or a report which is the main working mode for me. Currently the only option I know of is to click on the row actions button and select 'Edit'. This is a lot of manual clicking…
-
Change height of the column title (top) row
Is there a way to change the height of the column name row? Some of the column names are longer and I want to be able to wrap the column name. Appreciate your help.
-
Database of information from one sheet to another
Hi all, I have a sheet that is a "database" of about 400 records. I want other users to be able to input one column of that sheet (Media Company Dropdown) in a form or other sheet and for the next seven columns to autopopulate. Is this possible? Would VLOOKUP be a solution? I've read a few forum posts that said that…
-
I need help creating a formula for identifying task status
Here is the formula I'm using... =IF([End Date]56 > TODAY() + 7, "Future Task", IF(AND([End Date]56 < TODAY() + 7, [End Date]56 > TODAY(), [% Complete]56 < 1), "On Schedule", IF(AND([End Date]56 < TODAY(), [% Complete]56 < 1), "Late", "Complete"))) The formula works to identify Future and Late tasks. How do I update the…
-
Timelines
Hello Community! Is there a way to make a timeline in days instead of in dates? Like total timeline of 2 weeks as opposed to 1/1/19-1/14/19? Please help me out!
-
Find Value in List in Cell
I have two sheets---one with a list of program that includes rows with a cell that has a list of course prefixes. EXAMPLE: ROW 1--->Doe, John | doej@xx.com | BUS,CUL,MGT ROW 2--->Smith, Elle | smithe@xx.com | HOS,SUS Each row has three columns: name, e-mail address, and course code prefixes. On the second sheet, I want to…
-
Conditionally Formatting Children
I am using Conditional Formatting to change the background color of a row based on the value of a cell in that row. I want to visually distinguish courses on a course development list belonging to certain colleges. FOR EXAMPLE If College="UC", color background yellow. If College="PS", color background light blue. I am…
-
Survey for each client project (multiple forms one sheet)
I have a set of surveys which we have been sent out through smartsheet, each on their own sheet. At the end of the year, I am required to export all results and consolidate them for a year overall report. To help streamline this I have created multiple forms in one sheet for this year. What I need is to be able to label…
-
Share Data Across Two Sheets
I have a master sheet with data for a list of courses to be developed in the new term. I am working with a vendor on some of those course. Let's say 10 of the 15 courses. The sheet also has a column indicating the status of the development. I do not want the vendor to edit or view this sheet. Instead, my thought was to…
