-
How to link multiple cells, on multiple projects with ease
I'm managing 71 construction projects. I use one sheet per project site to track 182 (start, finish, and "actual complete") tasks that vary, per project scope. (546 date cells per project) I'm needing to run multiple reports, containing all projects, with abilities to sort, add date altering functions like ("Cell" -30d),…
-
redirection of automation@smartsheet.com to receive incoming emails
I have set up an approval workflow for staff to request IT support from an external provider. A Manager approves the request and on doing so the line is sent to the help desk of the IT company. The IT company has an auto responder email that confirms that have received the request and the email responder starts the…
-
Bar chart used on Dashboard...goes to 150%??
Is there a way to edit/customize the % shown on a bar chart? Currently, bar chart goes to 120%, want to change range to 'up to' 100%. Can this be done?
-
Automated update request: single row versus multiple row.
I set up an automated workflow to request updates from assigned task contact in column. There are 5 assigned contacts with multiple rows assigned to each. The automated workflow triggered without any issues and all 5 received emails. However, 3 of the contacts received on email listing out each of the rows and 2 of the…
-
Is it possible to set up conditional formatting to alert when a duplicate entry is inputted?
Is it possible to set up conditional formatting to highlight or alert someone if a duplicate entry is being inputted? I am looking to highlight the DOC ID if it has previously been entered into the sheet.
-
I am stuck with 25000 limit
Hello. I am trying to summarize data from some smartsheets into another smartsheet. I moved from VLOOKUP to INDEX MATCH. However, I have hit the 25000 error again using the formula below: =INDEX({DIGITAL RAIL 52 Weeks}, MATCH($Description@row, {Digital RAIL Description Only}, 0), 2) What I need to do is increase the 2 on…
-
Automation Disabling?
Hi! If you disable automatons so that when you're editing a sheet in bulk you do not want people to get tons of notifications, when you turn them back on right after you edit, will they still get those notifications or no?
-
Alert "Worksheet Title"
Is it possible to exclude the Title name of the Sheet from a workflow automated email alert? I have multiple sheets shared across with multiple different users. These users are only to enter their stats by the Report and not directly within the sheets. The goal is to automatically alert all users through email on a…
-
Gantt Chart and Resources
Good evening, Looking to see if someone can point me in the right direction? We are a fabrication facility that has resources both human and robotic. We are looking to track projects as they come thru our fabrication shop but we need to enable the resources to be allocated to the following amount of time per week Python:…
-
Problem with #invalidrefs
I have built a datasheet, which pulls data from a source sheet ("PD Database"). I added over a hundred formula to the datasheet, along the lines of: =SUMIFS({PD database Range 5}, {PD Database Range 4}, "PL", {PD Database Range 3}, "No") The formula were all working fine, and data was being pulled across into the datasheet…
