-
Can I change tasks visibility in a shared smartsheet?
Hi, I am trying to find out the best way to work with smartsheet in a particular scenario. I have project smartsheets that outline project milestones, and tasks within. This sheet is shared externally to my team for collaboration. In many cases, some of the tasks might drive subtasks, or small actions that the internal…
-
Is it possible to have a fixed URL to a sheet with filters without having to create a report?
Different users would like to see different set of rows in a large sheet based on filters. I do understand that I can create a report for each filter combination. However, if I do not want to create a zillion reports, but create filters and embed links to the "filtered" sheet in a dashboard, is that possible?
-
Automated Copy Row Function
Good afternoon We have a master sheet that we need to create additional sheets from based on values in a column. We will be using the automated copy row function. How do we make sure that when one row is changed in either sheet that it changes the other sheet....so if the master sheet changes so does the added sheet and…
-
How can I specify a range in one column and return a value in another column?
I want something like this (that works:-)) =IF([Estimated Days to Completion]<10, "Red", IF [Estimated Days to Completion]>10, "Green") So, if I specify a value less than 10 in one column, a red dot appears in the other column. Same idea for green. Thanks.
-
Can I customize the Confirmation emails from the Approvals Workflows?
Hi, I have an approval workflow set up and I have multiple stages to it. When the approver submits their approve or decline the confirmation email they get has all of the smartsheet fields smashed together horizontally in the email. Is there a way to either customize this email so that only certain fields display or no…
-
How to export the relation of a table: attachment and line/raw uploaded to
I can export table and all the attachments within, or i can do a backup of the whole file with all attachments from the home (list)overview, but in both ways, i can't find the information in which line the attachment was uploaded to. But this is important to me since i have 122 attachments per sheet! Smartsheet table and…
-
Photo Rotation Question
I have a construction punch list that we are using to compile descriptions and photos of items that need correction. The photos are taken on site via the app, and directly uploaded to an individual cell. The thumbnails seen in the overall sheet are rotated properly (guessing via EXIF), but when double clicked for a closer…
-
Do daily update requests get sent out during non-workdays?
We have an update request that will ask foremen to update the percent of a job they have done. The update request is set to trigger daily by using the date trigger option in the automation menu. Would these requests be sent out during non-workdays?
-
How can I restore rows after moving it to another sheet?
Dear all, I moved some rows to another sheet but now I could not restore it. Please help me to clarify it. Thank you. Best Regards, Phuong Truong
-
Is there a way to automatically copy filtered content from sheet A to sheet B daily?
I have a sheet (sheet A) that is my source sheet, and the content is updated frequently. I'd like to filter sheet A on a particular column, and copy the filtered content to another sheet (sheet B) to share with my users, automatically at a daily basis. Before copy, content in sheet B needs to be cleared. I tried to use the…