-
Combine values in column only if value in each row is less than a value
I have a column with an identifier in each row and in another column I have a value in each row. I want to search the second row for any values that are less than a reference cell, and if less that that reference cell, I want the text from the first column to be displayed in the cell the formula is in separated by , if…
-
Meeting Recording
Hello Admins, I attended session on "Intro to WorkApps" occurred on December 08 2021. Can anyone send the session recording video?
-
Graphs from Excel into Smartsheet
Is there a way to take a graph that was created in Excel and import it into a Smartsheet? I can do it via a dashboard but I would like to have it directly on the sheet with the data.
-
Copy and move row workflow disabled by smartsheet
My copy/move row workflows (that previously worked) were disabled yesterday. I now have an error that says "Rows can't be added to the destination sheet because a column has the same name as a system column on the source sheet." Anyone else have this issue? If this is new functionality, then the workflow will only work…
-
Editable Report with Shared Sheet that's Hidden/Locked
Is there a way to make the report editable by the user with a sheet that is shared to them as "Editor - cannot share", but making it to where they can't alter the actual properties of the sheet itself? Thanks in advance!
-
Smartsheet - Logging me out / Closing while working
Smartsheet is logging me out / closing while I'm working on it. I have submitted a support ticket, but have not received any response or feedback. Is anyone else experiencing this issue? It seems similar to the issue that happened on 11/5/21.
-
Trying to find a way to update information on existing rows via a form (not via update request)
Hello Smartsheet Community. I have a customer who has uploaded an existing excel spreadsheet into Smartsheet (about 200 rows) which includes information such as email address, first name, last name, etc. as columns. We have created a form to capture new information to each row. Is there a way to set it up so that the new…
-
Need a option to copy only changes for last 7 days
There is a good option to review changes in last say x hours and day , I would like to know how to copy all rows where last changes happened for that filter to only copy and paste to someone asking for delta work for last say 7 days ?
-
How can I share a report to an user without sharing him paper, source of report?
I would share some data in a report with an user but I do not want share with him the paper, source of report. The aim is to use report as a tool able to visualize data for all users and to track and modify data on a paper used only by our project managers. Thank's you
-
Avoiding #INVALID DATA TYPE when cells are blank
Hello, I am setting up a staffing leave Smartsheet for my team and unfortunately I am getting the #INVALID DATA TYPE error message. There are 2 formulae set up within the sheet: Leave Remaining (the dark grey row) is calculated as follows: =[Leave Allowance] - Taken + [Leave Bought] + Carried + [Long Service] Taken (the…