-
Sheet notifications
I have been getting a daily notification by email of sheet changes for a while and that has been working great. After one of the smartsheet updates it also started appearing under notifications in the top right corner. That notification is redundant to the emails. Is there any way to turn it off?
-
Mirror Smartsheets
Hi all, I am trying to find a way to mirror a certain area from one smartsheet to another. The problem I am facing is that some cells are locked and I couldn't find a way to automatically create rows and columns in the sheet it it pointing out to. Does anybody here have an idea if there is a solution to that? Many thanks :)
-
Nested IF statement - with checkboxes
I am looking for an IF statement to check the box if true, but do not check the box if NOT true. =IF([Actual Response Date]47 <= [Response Due Date]47, 1, IF((ISBLANK[Actual Response Date]47), " ")) I have an Actual response date, so when the date is over the due date OR is blank, I do not want the checkbox to have a…
-
Creating an Alert for Attachments
I'm using a Form to collect data that is populated in Smartsheet, and the form asks each user to include an attachment with their submission. I'd like to be able to mandate that the form cannot be submitted without an attachment OR set up an auto-notification to the user submitting the form to submit an attachment if that…
-
Outlook Online is stuck on Connecting to Office 365
After adding the app, while adding Smartsheets on Outlook Online I get stuck in Step 6. "In the add-in panel on Connect to Office 365." I click on Connect to Office365, click the user to sign-in (my only username) and get a constant thinking wheel. Any ideas?
-
Sum every other row
How do I add up values of all odd or all even rows? I've tried =SUMWIN(WIN1:WIN119,MOD(ROW(WIN1:WIN119)+1,2)) but it didn't work (WIN is the title of the column)
-
multiple date columns
i have created a sheet that has a notification date column and then a start date column and then an end date column. i only want the ghant chart to pick up the start and end date columns and not the notification date column. how do i do this???
-
Continuous Formatting
I have a sheet that is used to log data. New data is added several times a day. The sheet currently contains data through line 2223, however I can only format the next 20 rows because that's all the more the sheet will allow. Once I've entered data into line 2243, another 20 rows will be available to format. Is there any…
-
Is there a way to auto-populate a field on a form to match the same field on another form?
I'm trying to create a 3-step, or 3-page, Production Order for commercial production. One page would be for client info, one for script details, and one for editing details for each commercial. I have it set to automatically take the user to the next step once they hit submit. So each step (Parent Row, script, each edit)…
-
% allocation
I have read a few posts regarding the inability of the tool to automatically update duration based on changing % allocation of a resource i.e. Task A will be completed with 1 day duration by Resource X. I change Resource X to 50% allocation and the duration should automatically be updated to 2 days. The last post I read…
