-
DATA BASES
MY NAME IS RAFAEL AND I START MY SMARTSHEET, AM GOING WELL , ONLY NEED SOLVE ONE QUESTION. HOW TO USE A DATA BASE, REALLY 7, ARE FOR THE IMPORTANT DATA AND FORMS REGARDING AND USEFUL THE EACH TASK. LIKE PRODUCTION ORDER, PURCHASE ORDER, INVOICE , QUOTITATIONS, CLIENTS AND TEAMMATES IN THIS OFFICE OR CHANGED TO THE OTHER…
-
Removing completed tasks
How should I remove completed tasks? I see that "done" crosses out the task, but I want the task to move to an archive. New to SmartSheets. I think this is the tool for me, but I am still testing. Thank you
-
Updating Sheets
Hi everyone. i have a sheet where all entries are made via a form. all of the users with access to the sheet are "Editors, can/can not share". Today they attempted to add or change data to a line and save. when they went back into the sheet, the changes were not made. Any idea what is going on? I am the sheet owner and can…
-
How to count without including duplicates?
I want to count a list of names without including duplicates. This is a list of all publications our group had last year. Some people had more than 1 publication, but I want to know how many total faculty of each appointment type had publications. I want to first filter by column A (journal vs poster publication), then…
-
Conditional Formatting on Date is not taking into account local account timezone settings
Conditional formatting using a date, is not taking into account the local account regional settings/timezone and appears to be using a default time zone. As conditions like change the color of a cell if the date in that cell = Today, is still highlighting the cell on the next day. My Time zone is set to Australia/NSW…
-
Unable to Copy and Paste
Hey all, I am currently unable to copy and paste text from Microsoft Outlook into Smartsheet. I can copy and paste text from within Smartsheet forms, but cannot paste text from any other sources outside Smartsheet. I was able to use this function until it suddenly stopped working yesterday. I utilize this function every…
-
Date range formula
I am trying to write a date range formula with an IF AND statement (I think). I need to check a box if [Previous date] is in a specific date range.
-
Forms setup
Hi, Does anyone knows if there is any plan to enable editing forms in terms of font size, etc.? I have over 20 points in manufacturing area where operators reports their work and any issues in production flow, but fonts are too small for some of older guys and only because of no possibility to edit it, I have to cancel my…
-
Adjusting trip start/end date based on certain members holidays
Hi everybody, I'm new to smartsheets and I'm not sure if there's a name for what I'm looking to do. I volunteer for a small afforestation project in my local area. And want to make planning our planting trips a bit easier, as all our members are college students with varying schedules and holidays planned. (I already have…
-
Help to create a formula that sums a column based on if values in two other colums are correct.
Hello, I have three columns that need to be in a formula. TIME, Y, Z I Want to SUM all the rows under the "TIME" column based on if the Y and Z columns have the specific dropdown value. This was my try but it did not work: =SUMIFS([Z]:[Z]; "Approved"; [Y]:[Y], "", Time:Time) Can anyone help? Kind Regards, Hugo Martinwall
