-
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…
-
Workspace - Is that Possible to share with Non Users?
Dear All, Currently. we are able to share spreadsheet with Non Users, when we make the file as "public", then, no one needs a password, our team, can just access the file. Now, we are trying to do the same with a workspace, but we could not found anything like that. Do you know if this is possible? Thank you so much for…
-
Calendar in Smartsheet - selecting a date many years ago
Hello, I'm setting up a form for my colleagues using Smartsheet, and have included a date field using the "Calendar" option. In most cases, the date they select will be anywhere from the 1980s to 2015. The calendar option defaults to the current date, and as far as I can tell, there isn't an option to select a year, then…
