-
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…
-
New Logo Placement - Logo is tiny
Since you have moved the logo to teh left this actual logo display is way smaller and looks pretty naff. How can we keep a decent size that still makes the logo attractive and readable?
-
Sights font size
Hi, Is there any way to choose larger font size than 36? I have a large 50" screen which shows 5 tiles with 4 rows of data, that is updated every minute (since today's enhancement of auto-update). It works perfectly! Love it! BUT: The biggest font is 36, so numbers are visible from couple of meters, but if I step further…
