-
Is there a way to use Automation to update a Duration column?
I have a helper column currently that checks to see if a task is required or not, and I want to set my duration to 0d if it is not required. Right now, I am doing this manually as I can't see a way to get automation to update a Duration column using the "Change a Cell Value" option. Is there a way to do this via Automation?
-
Automatically Copying Cell Data in a Row
How do I automatically copy "Bill to" Name, Address, City, State, & Zip information to corresponding "Jobsite" cells, when the information is the same, by simply checking a "Same As billing" Checkbox on a Form? I tried this by using a formula on the sheet, and it worked well on the sheet but, when new "Forms" were…
-
Moved: Automatically Copying Cell Data in a Row
This discussion has been moved.
-
Expose Dashboard Widget APIs
It would be valuable to be able to create and modify dashboard widgets via the API. Currently the only way to bulk update content is via control center, and that still creates copies of the dashboard from the template set. With API access users could point to specific formatting options, as well as leverage information…
-
Date Formula Help
I am trying to create a formula to pull a date into the Future Date column based on the report frequency and due date entered. =IF([Report Frequency]@row = "Yearly", DATE(YEAR([Due Date]@row) + 1, MONTH([Due Date]@row), DAY([Due Date]@row)), "") Above is what I entered, but it is throwing an invalid column value error. Can…
-
How to collect contacts to the "assigned to" column
HI, I'm trying to build flow in my project set-up to handle the "assigned to" column and as I have around 200 tasks in my standard project I want to make it as easy for me as possible :-) I have a sheet for estimating time spent on tasks where I assign time for each task in a column for each profession. Some tasks are…
-
Hello from the Snow
Hello, I am a Program and Grants writing for MSU. I am a HUGE advocate of Smartsheet and thrilled to be using it again professionally!
-
Subtract Invoice amount from Total based on Status, in Parent-Child relationship
Hi all, I am new to create sheets, but I am trying to create a solution to track forecasted invoices that need to be sent out. I want to put each invoice total separately and when the status is marked as "Complete" I would like to have it subtracted from the Contract Amount to show the Contract Balance. I set it up so the…
-
Remove User Sharing
Smartsheet recently changed what happens when you click "Remove Sharing" from a user you are deactivating or has been deactivated. Previously, a banner would appear indicating if that person was NOT shared to anything. If they were shared, the banner would say check back later. When you checked back, it would show the user…
-
#INVALID DATA TYPE in Rankeq function
Following function flags #INVALID data type error. =RANKEQ([Row No]@row, COLLECT([Row No]:[Row No], [Project Name]:[Project Name], [Project Name]@row), 1) Column [Row No] type is Text/Number COLLECT function is getting executed properly. I have debugged it separately. It is collecting the values of [Row No] column. Will…
