-
Form Sharing
Hello, I know there is a security option in Forms to "Require people to login to Smartsheet to access this form" but is it possible to share only with intended users, or just shared users in the same Workspace? To get people to login is not the best security since anyone can create an account, and if I want to restrict the…
-
COUNT IF TWO CONDITIONS ARE MET
Hi! I have this formula to identify if all my status are "Completo" then turn the cell "Completo", but if a children status is "Sin iniciar" then the status must stay "Sin terminar". But I want to include another status in my column "Condicionado", so I want that if all my status are "Completo" or "Conditionado" change the…
-
Cross Functional Formula skip cells
I created 12 cross functional formulas in my sheet. They were working fine for months. Recently they do not populate in all of the cells. When I check the sheet the formula is pulling from, the information is present but it does not appear in the sheet where I need the results. I have tried the following but I am not…
-
Trouble with Move Rows automation workflow
Hi, I'm having trouble with the 'move rows' automation workflow. I've used it successfully before, but for some reason it's not working with the 2 sheets I'm using this time. I have an 'open requests' sheet and a 'completed requests' sheet. When a set of criteria are met, I want rows to move from the open requests to the…
-
Has anyone successfully triggered an alert using only a checkbox as the requirement?
I created an alert to trigger when a check box is "Checked," however, the alert has still not arrived in my email, including the spam folder. I wanted this to print out a request for our working files without manually creating an "Update Request" each time I need one. I have tried the trigger as both "When rows are…
-
Burndown chart?
Hello everyone! Does anyone have a burndown chart template that they would be willing to share? thanks Steve
-
how to automatically add a date when another cell value is added
I am trying to add in a formula to automatically add the date in the "date completed" cell when the "completed initials" drop down value has been added. What is the correct formula to make this work? I want the date to automatically populate when the job has been completed.
-
Form Files
Hello, I understand there is only one area in the spreadsheet to hold uploaded files, however I am wondering if there is a way to have more than one section on an actual form for files to be uploaded. If the file section is noted as required but does not have a quantity of files required, they would be able to surpass the…
-
Project Dates
I am having difficulty changing project beginning and end dates. Looks like I am not the only one. Is there a way to do this without adding a column and formulas? For a program like this I would think there should be a easy fix. Is there a way to disable the parent dependency?
-
Reports - Some fields can be updated?
Hello. I have created a report, and I noticed that some fields can be updated and others cannot. For example: I can update: task descriptions, start date, Health, percent complete, and notes/comments I cannot update: End date, task owner. Any idea where I can change this update everything or why it working like this?
