-
Error while uploading attachments
When i try to upload files to the smart sheet , any mail attachments or documents. I'm getting an error message and it doesn't allow me to upload the attachment.I have attached the screenshot of the error message. please help me with the same.
-
Automation / Update Request
Is it possible to set up an Automation / Workflow which will send a weekly reminder of any Update Requests that haven't been completed?
-
SUMIFS of a value that falls between a rolling date range
Good Morning, I am struggling with the SUMIFS function. I have a sheet that contains job orders. The job orders have a planned start date. The jobs are also categorized by Job Type. I have the following columns: Job Type Planned Start JSH *job site hours* What I need is to calculate the sum of total JSH if the job falls…
-
IF formula mix AND & OR functions, dates on modified and created columns
I'm looking to add a formula which will check the dates in modified and created columns and update the status column. If the modified date is today and is greater than the created date I want to populate the Status column with "updated", but if the modified date is equal to today and if the created date is also equal to…
-
Counting number of submissions and various stages
Hi I'm new to Smartsheet and trying to figure out ways it can help me keep track of the work we have ongoing in the department. At the moment I have an excel spreadsheet where I enter every new submission to we make to an outside authority, a new line when it is validated and then another when it has been approved. My boss…
-
RYG Formula Average
Is there a way to take the average of the RYG colors and roll it up to an overall summary for a section and then the overall section to the overall project summary? I've included a snapshot of what I'm talking about.
-
Stop Modified date updating for formula cell/column
Hi, I have a formula in place to have a certain value in a cell if the modified date is today "Updated", and if not display a different value "Not Updated". However, this seems to work when I open my sheet the next day the value is "Not Updated", but then the modified date updates after saving, because the formula has…
-
Auto-populate a cell based on column dropdown
Hello, and many thanks in advance for your help. I'm new to Smartsheet and spent some time looking through the various answers on this community forum and could not figure out the answer to this question. I've attached a screenshot of a smartsheet I've made. I added a section at the bottom of my sheet called Reference. My…
-
Dependency from a cell on another sheet
Hello, I run my manufacturing jobs on Smartsheet. I have one sheet with multiple projects on it, Parent row per project and tasks indented I have a few milestone dates in each project for equipment arriving (this date is linked from a shipment tracker) which other task tasks within the project are dependent on before the…
-
Storing documents in a folder, in a Workspace
Looking for best way to share and store documents (Word, Excel, Visio, PDF, etc) inside of a workspace. .. Ultimately, would like to have a tree of folders that will serve as a Data Room for a particular project. Has anyone tackled this previously? Any way to make it work effectively without having to attach to rows and…
