-
Question about data collection via form
Hello, I have a logic in the form that will request to fill some info based on the dept, e.g., if they select 4 depts, the form will show 4 sections of info to fill. The issue is each dept needs different info. The max # of dept is 20, which is a lot if they selected all of them. I wonder what I can do to make the data…
-
Checking for duplication across two fields
Hi Community Have used the formula posted to this forum to identify duplicates in a single column using [IF(COUNTIF())} formula. I have a site/dept type issue split across two columns and need to identify when the same site/dept combination has been used in another record. I have tried using AND in the COUNTIF() but just…
-
How to get attachment in the Alert Notification
Hello Everyone, I am trying to send the attachment to the other team member, my condition in the sheet is if the person checked the box in the sheet, the manager should receive the notification along with the attachment, which is attached to the row, but in my case, the attachment is not showing in the mail. Please suggest…
-
Formula not doing basic math correctly
im trying to build a metric for a dashboard that finds the percent difference between the actual and the required amount. for some reason going =[Required Capacity]@row / [Actual capacity]@row gives a different answer than =140.5/145.3
-
Slack Channel alert for a restricted sheet
Hi All, Is there a solution/work around for permiting alerts to a slack channel without reducing restrictions on the sheet to 'unrestricted' ? Kind regards,
-
Automation- Request an Update - Send to Contacts in a Cell Question
Good evening, I am wanting to request an update from an email address in a specific cell. My question is, am I able to recall a cell in a different sheet? I maintain a contact list in a different sheet and would like to reference that different sheets cell. I am not sure if this is possible, or if so, is there a specific…
-
Automated emails & US date format
Hi All, Just reaching out, if there are Australian users why is there not an option to select another date format other than US. For example I use this to send to Australian specialists around the nation automated updates via email which include ETA dates.. A lot freak out thinking I'm talking the 02/10/23 (2nd of October)…
-
Copy from Row to Row that include multiple Grid sheets
Hello, this may be an easy one to answer but I have a question. I have a Grid Sheet that I use per project, all projects use the exact same Sheet template. I then use a Project Intake Grid sheet which Row 1 might be rollup information for Project A grid sheet and Row 2 for rollup information for Project B grid sheet etc.…
-
URL as File Upload Option on Forms
When creating a Form and using the File Upload option, the only two options I see are to browse files or drag and drop. Is there a way to allow the user to paste a URL for the file they want attached? in Attachments there is an URL option, but I do not see how to use it on the Form.
-
Can a Master Dashboard automatically pick up a new Master Smartsheet links?
Hi, I have created a Master Dashboard in a folder with a Master Smartsheet and Reports - at risk tasks, Project Milestones and Status. My question is, if the dashboard widgets are always pulling data from the Master Smartsheet or reports and the reports are also pulling from the Master Smartsheet, can I just swap out the…