-
How do you attach files from Onedrive?
I attached some word documents to a sheet, and now smartsheet says "The link has expired" when I try to open them from Smartsheet. The funny thing is I'm the owner of the documents, and my onedrive account is set to not let links expire anyway, even if I weren't. I've tried removing them and reattaching, and it doesn't…
-
Want to send a row to a support portal, need to customize the sender/return address
I'm using a Smartsheet as a CS support issue repo. Support requests come in, I vet them, and some need to get injected into our Jira workflow. Our Jira service desk is set up to only receive emails from within our company domain. I didn't think that would be an issue, since I assumed the sender/return address used would be…
-
Slow forms, DynamicViews, late emails
Hi community, i am using smartsheet in my team and we have built a nice workflow web app with it. So far we are very confident with the various features of smartsheet but something is annoying: I have observed that between 8 am and 2 pm US time the server get more slower During that time: DynamicViews end in error. So when…
-
Linking Cells
I have a few questions regarding this. Can someone please confirm the amount of cells I can link out to another sheet per sheet please? It seems the number is 20,000 from what I read, but need to confirm. Also, is it possible to somehow link a cell to another cell on another sheet so that when it is clicked, it takes you…
-
Random words appear in Sheet Name when used in Report - Group By
I created a few reports that rolls up data from multiple sheets. Added Group By "Sheet Name". One of the sheet name displays some random words below the sheet name eg "Legal (Completed)" Then in another report that included the same sheet, shows up fine without these random words. Where do these random words come from and…
-
New Form submissions are added at the top of the sheet
How can I force new form submissions to be added at the top of the sheet? I have removed all of the blank rows from the sheet. I have two locked rows (#2 & #3) to divide the new submissions (requests) from the reviewed submissions (in progress). When a new form is submitted the new data is added after the last row (#3). I…
-
Message Attachments
When an automation is set up to Alert Someone, can Smartsheet send a pdf file attached the row with the Message without including access to the sheet or any fields?
-
Date Comparison in Functions is Not Working
The following formula returns a value of zero (0): =COUNTIFS({DATE ONLY}, =DATE@row, {Shift}, ="1st", {Degreaser Check Passed?}, <>"BLANK") Here is the sheet that is being referenced: DATE : Contains only dates or blank cells. (formula driven) {DATE ONLY} : References a column that contains only dates or blank cells.…
-
Logic - Can you define if text in entry then show x field, as opposed to number?
Hi all, I would like a field to show an error message if anything other than a number or a decimal place is entered, so no other characters. Is that possible? I'm assuming I can't use regex within the contains logic? Thanks in advance
-
Email Limitations for Email Alerts?
Is there a known bug that prevents email alerts from being sent to a generic or non-individual email? I have a workflow set up where the final step is that an email alert goes to a one of our office services staff for each office depending on the input from the form itself. For example, if the attorney is in the NYC office…
