-
URL String - Any common thread between Sheet and Form?
Hi there, I came across a circumstance where someone had a link to the form but forgot where the sheet lives. Is there anything within the URL of the form that can bring you to just the sheet? I tried cutting out the 'form' from the URL, but unsuccessful. TYIA!
-
Can i move child rows to another sheet and copy the parent row across too?
At the end of each quarter, i'd like to copy parent rows and move the previous 3 months (from each parent row) to an archive sheet. Is this possible? I'd then like to have an automation after this that adds 3 new rows under each parent row once a new quarter begins.
-
Moved row with attachments results in "the file you are trying to download is no longer available"
I am notifying users via "send" about a row that needs attention, and then I am moving these rows containing the attachments to a separate sheet. I have verified users permissions, (including my own as the sheet(s) owner. I have completed the below Share the Destination Sheet: Ensure that all relevant users have…
-
Sum Entire Column Starting at Row 4
I want to insert a Sum formula into Row 3 that will Sum all the rows in the column beginning at row 4 and continuing to sum any new rows that are added to the column. It seems like it should simply be =SUM([ColumnA]4:[ColumnA]) but this gets an #Unparseable error. How might I create a Sum excludes everything above Row 4…
-
複数のワークスペース間にシートを移動する場合の共有方法について
私は自社のライセンスユーザ（A社と言う）でありながら、本社のライセンスユーザー（B社と言う）でもあります。 両方のワークスペースは画面上に確認できます。 自社シート①を本社のワークスペースにシート①を移動したところ、共有者がリセットされます。（消えてしまう） 共有者を含めてすべてのシート情報を別のワークスペースに移動することが出来ないでしょうか。
-
Dynamic View: Change Source Sheet
I have a number of relatively complexly configured dynamic views (help text, display logic, etc.), and I need to preserve all of those features for each of the configurations (which I can accomplish via a save as new), but I also need change the source sheet. It would be nice to be able to change the source sheet for a…
-
Expand Support Case Description Text Box
Problem: The Support Case description text box only displays 3 lines with no capability to expand beyond this limit. This makes it difficult to reread and edit previously typed text. The scroll bar moves the cursor to the top or bottom of the box at a speed that is not readable. Using the cursor and arrow key is the other…
-
Expand Support Case Record View of the Subject Field Title
Problem: The Subject field title in the list of support cases only displays 23 characters, which makes it difficult to identify the cases without opening the entire record one at a time. Some cases contain similar, but not identical subject descriptions. This is a time consuming process, particularly when looking for a…
-
Need ideas on Creating Monthly Timesheet
Hi Smartsheet Gurus, I am planning to build a monthly timesheet for my team, which will have a) date b) no of hrs. worked for the date c) Total d) hours utilized for the whole year (sum of all months from July) e) total hours remaining (less the total hours utilized from 2000, 2000 is total assigned to a single user in a…
-
Limit Characters for Generate Documents
We need the ability to limit characters for situations like generating documents. If a user enters too many characters the data runs off the page. I found a workaround, but it requires sending the request back to the requestor. If it could limit from the onset there would be less manual effort.
