-
Clone sheet and reports between accounts
Hi there, I'd like to take a sheet and some reports that operate on that sheet, and clone them over to a new account programatically. I'm able to share the items, copy them, and then un-share them programatically, but the reports then point to a non-existing sheet. Since I have quite a number of reports I'd ideally like to…
-
Help with RYGB Formula Logic
I can't seem to get this formula to work properly, and my eyes are crossed now. Would someone be willing to take a look to see what I'm doing wrong? =IF(OR([% Complete]21 = 1, Complete21 = 1), "Green", IF(ISBLANK([Start Date]21), "", IF(AND([End Date]21 >= TODAY(), Complete21 <> 1), "Red", IF([Elapsed Duration]21 > [%…
-
Jan 10th, 2019: Cell Linking between sheets with the new UI
Is there any updated information for linking cells between sheets with the new UI? It looks like the direct way is still in tact (where you right-click on the destination cell, click on "Link cell from another sheet", and file through the sheets in a pane on the left until you find the source sheet, and then you click on…
-
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.
