Structures used to organize work
Hello, I'm interested in hearing ideas about any of the following: how you successfully use multiple sheets to organize phases of work across a project or program. For instance, has anyone had success tracking all phase 1-2 (for example: discovery and requirements gathering) tasks in one sheet and then, all phase 3 (build…
Is it possible to send ONLY an attachment as an alert?
Hello, Is it possible to send only an attachment as an alert WITHOUT the link to the sheet? I need to send them the file but do not want them to see or have access to the sheet at all. Please help, thanks!
How can I display milestones as diamonds in Calendar app
When I set up a sheet in Calendar app it displays milestones i.e. tasks with duration = 0d as bars. I am able to right-click and check the box for milestone. But I would like for the task to be displayed as a diamond instead of a bar with a small checkbox under. Is there a way to change the shape of a task in Calendar app?
Looking for your help on the webcontent widget for calendar. So I have added a calendar to my dashboard to track go live dates however I have a few questions: Can I colour code the entries based on a RAG column, i.e. if a project is red then it shows on the calendar as red. I tried adding conditional formatting at the…
Data Shuttle -
Hi, Need a thought partner :) Have a Source Sheet that is a Data Shuttle that runs on attachment - source of truth. I want to eventually pull pieces of that to a final 'workflow sheet'. If i just DS the additions to the source sheet, (even with Add (not replace) - it is overwriting. I thought I could Data Mesh the relevant…
HI, Is that possible to grant certain permissions to a user? For example, on my sheet, I want employee A be able to update Column A & B only; and employee B to update C&D columns only? Thanks, Bryan
Why can't I see 'At Risk' column in sheet summary?
I set up a column 'At Risk' with a formula to flag the rows if the task is past due date and not complete. I am trying to create a dashboard, insert metric widget, sheet summary data and choose the 'At Risk' column but I don't see it. How can I fix this?
Workflow: Repeat Email Address Instances
I have a column where there are 20+ instances of the same email address. If I create a workflow which sends an alert to all contacts in that column, will it send the alert 20+ times to the same email address? Or does SmartSheet have a failsafe which will only send the alert to that email once?
I really need to import or copy and paste contacts - but how?
Hi, I need to import, each week, a series of assigned rows from another system. As far as i can tell, the only way to do this is to copy text into the contacts cell and, laboriously, click on each one to change it to a contact. This will be about 1200 clicks, although I can reduce that by some dragging with rows in the…
How best to display Column headings that need to be grouped.
Hi there, Have a question regarding Column headings. In excel you can have a parent header and child headers as pictured example below - how would you achieve this in smartsheet?? Any help would be great. Thanks,