-
Reference another sheet using sheet name
I'm almost certain that there is no solution to this situation, however, here goes. I have a workspace with approximately 35 project sheets. Each project has approximately 50 tasks and each has a schedule status in a "Schedule" column. I want to be able to count these tasks based on their stats and report on the entire…
-
Loss of Function - Select/open multiple
We were able to browse any workspace or folder of favorites and select multiple sheets from them. then open them all at once - but this feature is now gone. Checked the text of the announcement. It says that in order to do the thing that was already working in Smartsheet, you have to use some other system built into the…
-
Countifs with with percentages
What am I doing wrong? The formula was fine when I did the tower in air dates from today - 12.31.19, but as soon as I tried to add the condition of lease probability being above 49% it doesn't work. Any thoughts are greatly appreciated! =COUNTIFS({C. *Ground Lease Tower In Air Date}, >=TODAY(), {C. *Ground Lease Tower In…
-
Extracting all instances of a word from a text string and creating a list in a separate cell
Hello all, I have been pouring through excel and smartsheet help forums for a couple of days now, and I haven't seen my issue asked or addressed so thought I'd ask here. I have, in one column called Terms, cells that contains lists of terms and phrases. For example, one cell contains the following text string:…
-
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!