-
Send as Attachment Feature
Is there a way to clean out the list of who was sent this way? I only want to see what items I have as recurring and not see ones I did as a one off.
-
Help on a formula
Hi there, I try to convert hours to duration, on a basis : 7 hours = 1 day. I made a formula that has been working so far. But my boss asked me to add a minute setting. So that's my formula : = IF(AND(Heures@row = "0,5"); 0,05; IF(AND(Heures@row = "1"); 0,1; IF(AND(Heures@row = "1,5"); 0,2; IF(AND(Heures@row = "2"); 0,3;…
-
Cell is considered "changed" when it goes from Blank to Filled - Why
I have a sheet set up that populates rows with information filled out from a Smartsheet form. Rows are only added by filling out the form. When a row is added (i.e. form is submitted) a notification is sent out to a mailing list of individuals. This all works fine. I have a separate workflow notification in the same sheet…
-
Automated Update Request Form Changes
I have built a tasklist. It is set up with a grant name being the primary field. We do monthly update requests via a form request. The form request is going to the resource name for the grant task. When the resource name receives their request, the forms are in grant order and not due date order. We would like the…
-
Dynamic SmartSheets an Option?
First-time poster and amateur SmartSheet user here. I have an existing Excel spreadsheet for our association's Marketing Schedule. Each month has a row and each marketing medium (newsletter, magazine, social media, online ad, etc.) has a column where I list all of the programs and services that will be featured in that…
-
REFRESH A SHEET
I linked two sheets (A and B) On sheet A are the name of customers from all country with other informations about them. Sheet B is the active sheet, I choose a country in a cell with a dropdown list. On other cells, I use VLOOK link to the dropdown list cells. Finally, by choosing a country name in the drowdown list I have…
-
IF and VLOOKUP?
Hi I'm not sure if should I use IF and VLOOKUP or maybe COLLECT with IF formula. What I would like to achieve: Smartsheet A - with list of the application name and ID Smartsheet B - with results of the evaluation, where is application name and ID as well and Repsondent Role, and Result I would like to collect the…
-
Question regarding guest accounts
Hi All, I am a member of my organizations IT Support team and I am currently researching an issue reported by one of our internal users: We have a user outside of our organization that has been invited to work on some smartsheet documents with some of our users. I believe this is through a guest account that was given…
-
Export Entire Folder to pdf and include gantt charts
Hello, I like how the feature to export an individual sheet to a pdf view gantt chart view. However, if you try to export several sheets from one folder, the gantt charts will not show. I would like the ability to export all sheets into one document that will display gantt information. Thanks in advance on possible…
-
Default Open to Bottom of Sheet?
When I open a sheet it always opens at the top (row 1.) Is there a way to have my sheets open at the bottom of the sheet or where I last left off instead?
