-
Smartsheets Budget Forecasting
Hello, I am trying to create a custom sheet. It would be a calendar with a nested daily budget. For each day of the week we would be able to update the expenses or add budget forecasting. It should also show the running monthly and yearly total.
-
Employee In Take Form: Trying to auto check selections based on 1 and 2 column criteria.
I have many columns created with a checkbox. Ten columns are labeled as required devices for employee types. [Employee type column named "Role"] When a certain employee type is entered in the "Role" column the "Devices" column check boxes would be auto selected showing what devices are required for that Role. Example: If…
-
IF NOT ISBLANK help
I'm trying to create a formula that will display the different colored dots in the status bar. I had success at first but one part of the formula isn't working with the others. I need it to display BLANK if Patient is blank, Gray if patient is filled in but Order Request Date is blank, Green if Complete date is filled in,…
-
Adding updates to cells
Hello everyone I need some assistance in updating individual cells. Listed below are columns, each one pertaining to external software tools we check daily. The rows are network elements. If a tool is ready, my team would mark the cell, corresponding to that network element with a Y to indicate it's ready. N is not ready…
-
How to use any date within a date range as formula criteria?
O, great wizards of the Smartsheet community, hoping you can help me cast a formula spell. Trying to create a formula to flag if a resource is overallocated in a master sheet that tracks resources across multiple projects. NOT using either the legacy resource management or RM by SS, just core Sheet functionality. I managed…
-
What is the sheet limit for a free trial user?
I'm using the free trial and I'm getting a notification that I need to upgrade my plan to create more sheets. Does anyone know what the sheet limit is for the free trial, and where that information is shown? Thanks!
-
Add Contact details on bulk upload
I am trying to add contact details on the bulk upload but it allows me to add just name and email. I want to add Name, title, email, company name, office phone number, mobile phone number etc. how can i do that?
-
What reports are tied to a sheet?
Hi - is there a way to see which reports a particular sheet is feeding?
-
Moving singular cell data into a sheet from a master sheet with autonomy?
I am sure this has been asked before, but I have scoured many forums and attempted many solutions but to no avail. My issue: I have a sheet (let's call it master) that holds metadata. I also have another sheet (let's call it Department) that relies on a single piece of metadata from Master, but also requires the ability to…
-
Recording Week Tasks Were Completed
Hi all! I'm back with an old problem that rattled me a few months ago. Basically, when a task is completed, its date of completion is saved. For the sake of being able to a process this data in a more comprehensive manner, we want to take that date, and assign it a "weekOfCompletion". Another note, is that the weeks here…
