-
Unicode character to allow blank rows in forms
In the spirit of sharing, I thought I'd let you all in on the Arial Unicode Right-To-Left Mark character that can be used in forms to add blank row between Help Text and the form value. As per the image below: * begin by selecting and copying the U+200F character from the Arial set in the Windows Character Map application.…
-
Notification Dates
Is there a way to edit the dates for when to set a notification past 14 days? We are looking at a way that this can be edited when we need notice 3 weeks in advanced or any specific number of days.
-
If multiple cells are blank or a one specific cell has data
I am trying to achieve this - If the action required by and the data processed is blank or the action required by = "DAT", then "DAT" is the correct response. This what I have come up with =IF(OR(AND(ISBLANK([Action Required by]1), ISBLANK([Data Processed]1)), ([Action Required by]1=DAT)), "DAT") Am not sure how to fix…
-
Webhooks API
Hello, Does anyone have any good examples of using the webhooks feature of the API to send notifications to Slack? I'm not sure if I have everything structured correctly in Smartsheet but, essentially whenever a certain cell in a sheet (that could live in a specific set of Workspaces), I would like to have a slack…
-
Keeping Parent Card / Subtask relationship when moving card to another sheet.
Hello everyone. I was wondering if there is a way to keep the relationship between a parent card and its subtask intact when moving a sub-task between sheets. In our case this would be various departments who are assigned a sub-task then the card is moved to that departments board. When complete, the department would move…
-
How to manage Order with multiple items
I'm creating a form to collect Order information from users and facing a difficulty with an order having multiple items. I want to create a form which allows users to input multiple items in one order request. Each item will have each price and quantity. How can I do that in smartsheet? Thanks.
-
Feature request: copy share link to clipboard
I would love to save myself a few clicks by having the "Secure sheet link (accessible by shared users only)" link available in the main UI. My mock-up of this would be something like the attached. A user could just click that small hyperlink icon and the share link would be copied to their clipboard for pasting. I do a lot…
-
Production Data Report
I am looking for help on setting up a dashboard of sorts to summarize monthly production data. What I have now in excel is that I can select a month from a drop down menu, and then the data fills into several tables I have made based on the selected month. Is there a way to have a similar setup within smart sheets? I…
-
Copying Links of a single cell to multiples on another sheet
Has anyone else had a problem copying a link to one reference cell to multiples on another sheet? We have the problem of trying to link a single reference number on a master sheet to a group of candidates on a second sheet. Functionality-wise I want a change in the master board to immediately update on the secondary list…
-
Yet another RYG Balls Question
Hi all, Can someone either let me know or point in the direction of a post that would assist me in solving for the following. I am trying to create a formula that would: * Return red ball if date in a column titled "Last contacted" contains a date that is 30 days or over. * Return a yellow ball if the same column has a…
