-
can a person submitting a form save it if they need to come back to it later?
I have created a form that requires a lot of information before it can be submitted. The person completing the form may not have all the information at hand or may get interrupted while completing the form. Is there a way the person can save what has been entered so far and come back to it later? Is the only to keep the…
-
Trying to convert a form to smartsheet and having problems
Hello and Thank You in advance for any guidance you may be able to provide. I'm trying to convert a form that i use to track FTE changes into smartsheet. What I need to have is a section that allows for multiple responses for each type of FTE (Admin, Clinical, Educational or Research) some that might be the same (for…
-
Report Names, Dashboard Titles and Widget Names with non-static strings
The name of reports, dashboards and widgets are limited to static strings, so the user will only know the name of the report and not what information is in the report. Example: The External Appeals Report title cannot be automatically updated to Q1 2022 External Appeals Report. Having automated strings based on the report,…
-
Proofing Download Not Working
Hello, I have a sheet with Proofing enabled. When a proof is sent to a reviewer with the allow download option enabled, the reviewer is unable to download the proof. When download is attempted, a new page opens up with an error message that says, "This link has been removed or cancelled." How can this be fixed? Thanks, Dan
-
IF OR Statement For % of completion
I am trying to write a formula that returns the status of the project based on a column labeled as "% Completion", if the % of completion is 100% then status should say complete. if "% of completion" is 10% then status should be in progress. This is what I have come up with but it's giving me "INCORRECT ARGUMENT"…
-
Link an individual task?
I've tried searching for this and haven't found info - I apologize if it's out there! Is it possible to send a link to an individual task? Sometimes, that's helpful. Since I group all relevant info into individual tasks on the card (e.g., attachments, links, and any conversation), it's sometimes really great to send a link…
-
Quickly Navigate Back to Smartsheet from WorkApps
Hi Community, Did you get tired of having to open a separate browser tab when you wanted to return to Smartsheet from a WorkApp? We sure did, well not anymore! Our latest update allows users to seamlessly navigate from WorkApps back to their work in Smartsheet with just one click by selecting the Smartsheet icon on the…
-
HELP: sending automated notifications to multiple contacts in a cell
Hi Folks Is there a way to send an automated email (via workflow) to multiple comma-separated emails in a cell ? I have tried, but so far have failed. Nothing seems to happen when I trigger the workflow. Any help would be appreciated.
-
Mark Duplicates In Multiselect Dropdown Contacts Column vs Employee Names List?
Ok, we're making a labor schedule, and want to be able to note when and where someone is used multiple times so we can prevent overscheduling someone and ensuring proper manpower. With the above as an example, I want to highlight a cell in [Employees on Job] (multiselect dropdown contacts) column, when one of the values in…
-
Can someone help me figure out why my multiple IF formula will not work?
=IF([PO Type]@row = "Standard With Quote", [Quote Amount (ESTIMATING)]@row - [PO Amount Including Change Orders ]@row),IF([PO Type]@row = "Non Standard No Quote", [Original PO Amount (Labor Only If Req) (PO Admin)]@row)) Everything is fine until I add the second "IF" statement. Thanks in advance.
