-
Cross sheet formulas with TODAY()
Hi guys, I have a master sheet with a "TODAY()" formula and some other cells related to TODAY(). And in an other sheet, I have references to this cells. My question is : if noone opens the master sheet, will the formulas linked to the "=TODAY()" cell be up to date ? Thanks ! Paul.
-
Uncategorized Column
I'm using the Card View as an intake workflow. Is there a way to rename the "Uncategorized" Column? When a new intake request is created via the form, I'd like the request to automatically go into a "New Request" column, not "Uncategorized". Thanks!
-
Sharing Reports
I support a team of graphic designers and I created a report showing them all their projects and tasks. I thought the designers would be able to sort the reports by date, sheet name, % complete, etc, as they need to to organize their workload. But I'm finding out that they are not able to do this even though they have…
-
Formula to update status value
Hi, I would like to create a formula to update the value in the status field (it's a drop-down list). If the start date is in the future = "Not Started," if it's in the past = "In Progress," if it's 100% Complete, then "Complete." I've tried and get an unparseable error. Any help would be appreciated!
-
Text- Mid formula
Hello, I am trying to extract certain words from a string of text using the "MID" formula in excel. Is this something I can do in smarthsheet?
-
Inventory Sheet, moving data to/from Excel and SmartSheet
Hello all, While I have a lot of experience with Excel, I am new to Smartsheet. I've been given a project and I'm having difficulty finding a way to perform what I need in Smartsheet, and am looking for advice/help. Effectively, I have a master inventory list that is kept in Smartsheet of equipment we are configuring and…
-
Workspace cleanup too many objects
Is there a work-around here for this situation? Customer has a single workspace of more than 100 objects. MUCH more. At the root level they have a half-dozen or so folders and about 20 Sheets/Reports/Templates. Under each folder, there are one or more folders and one or more objects. The limit on Save as New of the…
-
Auto Populating Report or Sheet with New Rows from Master Sheet
Hello- I'm trying to figure out how to automatically pull in new rows (either using cell linking or reporting) from one sheet, while having columns editable from another sheet. For example, I have one sheet that is a master list of all projects in my organization. We continually add new projects to this sheet. Each project…
-
Custom email notifications
We use smartsheet to track enhancement tickets that is logged with us, I would like to setup a "custom" email that is triggered for every phase a ticket might go to, example move from phase 1 to 2 then a custom email gets trigered with our companys custom info and details around the ticket. ? We have an outside logging…
-
Auto populate field on form
I am trying to have a field auto populate in a form, however only a portion of the field will come through. The fields that are linked have several lines of text with skipped lines. Am I missing a simple functionality so that the entire text in that field will come through?
