-
Where has my automation gone?!
Hello I've inherited some sheets from a colleague. When they handed them over, there were a number of automations set up on a sheet as well as a dashboard. Today, I've viewed the sheet. There are no automations and the dashboard is asking me to add my first widget. Where has it all gone?! I've tried the Activity log for…
-
Formula returning 'Invalid Operation'
Hello, I'm having trouble with my formula and can't quite figure out how to fix it. =IF(AND([LookUp Value]10 = "Y", {April THD Tech on Call WK1} = 1), JOIN(COLLECT({April THD Tech on Call Name}, {April THD Tech on Call WK1 TOC}, HAS(@cell, [LookUp Value]2)))) Anything obvious that I am missing?
-
Cross Sheet Input Numbers
I need to imput numbers from a different sheet using =Count for each line. If someone has a better structure idea this could be put into that would be appreciated. The issue I having to report numbers per month on the smartsheet using only cross sheet referencing. What i have come up with so far is =Countif({C Type},…
-
Calendar subscription not showing on all user iPhone/Mobile Outlook app
Hello supersmart community! I have a calendar view that has a link we can subscribe to in our Outlook calendars. Works great. The issue is that some users cannot add it to their Outlook app on their smartphone. It should show up like the image below, but it's not there or in any other calendar lists. They have subscribed…
-
Attempting PUT method on Reports "sourceSheets" field... Does anyone know what the API is expecting?
Hello! I am attempting to use the PUT method on a Report to update the source sheets, but cannot figure out how it wants the source sheets to be formatted.. Like what information do I need to put for each sheet in my array of sourceSheets? I am using Powershell. Here is my code so far: $token = <API TOKEN> $reportID = <ID…
-
Autofill Cells When New Rows Added
Hello! I am trying to figure out how I can autofill a column in a RAID Log sheet based on the project name entered in a cell in the Project Plan sheet. What I tried: First, in the RIAD Log I added a "Project Name Helper" column and linked it to the cell that has the project name in the Project Plan sheet. I then added a…
-
Can the auto-numbering function be set up to utilize new numbering prefix at start of each year?
I created a sheet that uses auto-numbering to assign a number to all submitted forms. I want the numbering to utilize a prefix denoting the year and start over at 0 each year. For example the numbering of the submissions in year 2021 will start with 2021-01 continuing with 2021-02, 2021-03, etc. When the year 2022 is…
-
proof creation only working in portfolio workapp
We recently tested creating a proof from both a standard workapp as well as the portfolio workapp that control center creates. I can upload the file from the standard workapp, but the invitation process does not work. I can fill out email and subject, click invite, but nothing happens. From the portfolio workapp, I can…
-
Publish a calendar showing times through 3rd party integration
Looking for a way to publish calendars to outlook and have them display at the correct times, not as all day events. Based on community post review, I am assuming the following: It is not currently possible to store a time in a date column (although the created/modified columns have that ability) Published calendars show…
-
Why is Smartsheet only adding one blank row instead of all the rows it read from G-sheet?
Hi, I'm trying to make a script from Apps Script to work with Smartsheet and I'm stuck. The script is to process some rows that need to be copied to a specific Smartsheet based on some filtering criteria, but after the script runs, we can see the following. Is there anything that might be preventing Smartsheet from pasting…