-
Filter not working properly anymore
I have one sheet with Status column with multiple Statuses. When my project is completed I check the status as Archived. I have a filter for Current projects, that filters out them archived projects. It worked fine for a while, but some short time ago it stopped filtering out newly created rows checked as Archived. Old…
-
Is it possible to change the definitions attached to the symbols?
To make it easier when asking others to complete a form, is it possible to change the 'Yes, No, Hold' definitions?
-
copying row to top of another sheet via automation
Hello, I have an automation in place that copies a row from one sheet to a secondary sheet but adds it to the bottom. As we're using this for a new hire process, I'd like the row to be added to the top of the sheet when copied. I have a column that records the time and date the submission was made and tried sorting on that…
-
Can workflows include rules to move rows only if not present on the recipeint sheet?
Hi, I am creating a "customer information system", where the customer will fill out a form with contact information ext. It will populate a sheet with added info including ticketnumber and delivery document information. I want to create a workflow that will copy the customers contact info and name into another sheet named…
-
Identifying Duplicates in a column
Hi, I am trying to identity duplicates in a column on a smart sheet but I don't think I am doing to formula correct. I did add a flag column and tried to enter the formula in there but its not working. I want to identify if there are any duplicate entries in the UNIT# column. Thank You,
-
For Multi-Contact cell is there a way to keep the contacts in the order they are inputed?
Every time I add a contact it arranges them alphabetically, is there any way of keeping them in the order they are entered in?
-
One off Saturdays in Gantt
Hi all, I work in construction and use the gantt chart heavily to manage scheduling subs. I have a unique situation for my project where I may have to schedule work on a Saturday. Is there any way to allow a single Saturday, instead of opening Saturdays for the duration of project?
-
Pictures using Windows Devices on forms
Does anyone know a way to directly take a picture and attach it to a form on a windows device? I have several microsoft surfaces, and I can't get the option to directly attach a picture to a form like you can with a phone, instead I have to open the camera app, take the picture, go into the form, and find the picture in…
-
Formulas for % Allocation in Resource Manager
Is it possible to use a formula to generate a percentage in a % Allocation column for use in the Project Resource Manager? Or does a percentage have to be manually entered into the % Allocation column? I've done quite a bit of research on it and haven't found a straight answer yet, but it seems as though having a formula…
-
Gantt chart - date fields ok from formulas?
Hi, all. I have data in table where two date columns are derived from formulas. When I try to use the Gantt chart functionality it says that my grid needs at least two dates columns and doesn't allow me to continue. I have two date columns but they are derived from formulas. Does the Gantt chart functionality not recognize…
