-
Automations question
I was helping a co-worker convert an Excel file to Smartsheet. One of the things she currently does manually is after entering new rows onto her Master file; she copies (manually) to each of the QMS Entities sheets. Now there are about 20 QMS entities. We looked at the Copy to sheet template automation, but it appears as…
-
Sort Rows Based On Date Order
Hi all, Trying to sort the rows on this sheet. Basically, I have a calendar and one column has a Live Date, I want the order to change and the row to move down in the order to a new position. Is this possible? Thanks Anthony
-
Smartsheet Form
I have a Smartsheet where users complete a form for new hires (hardware, software, etc.) requirements. Some fields are drop down lists that users complete the appropriate items for the request. Is there a way that I can export each request into a form that can include check boxes for each item? Fields in the sheet include…
-
Reports Not Generating Data from One Sheet Only
We have a report set up with the following column headers: The parameters of the report are set to include a specific sheet from each workspace that includes basically these same columns and that a row should display on this report IF there is not a Jira # (AZZLY Internal) number entered on the source sheet. This works for…
-
I'm being driven mad by random hierarchy changes
Something bizarre has been going on with my sheet for a few weeks now and I cannot figure it out. For privacy reasons I blocked stuff out so you can't quite see, but here goes. I entered these new rows last week. 214 was the parent row and 212 and 213 were the child rows. I opened the sheet today and suddently 212 is the…
-
Form Date Format defaults to MM/DD/YYYY even though Form is set to DD/MM/YYYY
Hi all I searched the topics and other questions but could not find a satisfactory answer. I am in the UK and have set my setting to DD/MM/YYYY but I'm using a US licence (global company) On the sheet, a date column is formatted to DD/MM/YYYY - when I open the form from the link, the date is DD/MM/YYYY but I can't change…
-
Pulling data from different sheets to master sheet based on single identical column
HI @Andrée Starå I have a master project sheet, where individuals from 5 subspecialities complete the form (from master project sheet) whenever they have the new project. This sheet collects the basic information like project name, objectives, subspeciality, summary etc. Whenever the individual submits this form, they…
-
How can I import big data (+20.000 rows) from excel files to SS?
Hi, Can you help me please?, I am getting an error during the importantion process from excel. I need to import a lot of date from excel and from different files, and my data is so big in all the cases because I need to analyse historical information so in my case I cannot cut any info. How can I do this in Smartsheet, how…
-
Smart Sheet Updates Not Loading
Good morning! I am currently having some trouble with my SmartSheet not saving after I make updates. For instance, after I update specific information on the form and refresh the page, the form/sheet reverts back to the information that was previously inputted. What are my next steps in ensuring that my sheet updates/saves…
-
Automation in Preventative Maintenence
Hey all, I'm trying to get it so that I have a recurring input every 4 weeks on the next open row? I'm using a template and I've got a linking column that identifies following the approval that a line is completed to lock and set the date for the row. Is it possible to take the task again move the start and end date by 31…