-
IF statement referencing another sheet
I'm new to Smartsheet and I'm trying to use an IF statement to pull data from another sheet based on "true" criteria. I want to look up a reference in a sheet based on an application name, and if it is true, I want to return the site # based (on the same reference sheet, different range), otherwise it returns "None". I…
-
Default properties for rows
I started a new sheet using the 'Template: Client Creative Brief'. I have subsequently changed most things, including the colors. However there seems to be default cell background color (dark blue, see QTY. column in attached screen shot) that shows up every time a create a new column. Does anyone know how this is set and…
-
formulas in update requests
Hi, i'd like to use smartsheet for end of year bonuses. I ideally would like to send an update request to managers with the info below. I can lock all cells so that the only one they can update would be column C - but is there a way on either update request or something where if they change the drop down of column C a new…
-
SUMIF with date range and dropdown list categories
Hi everyone, So I have columns Type (dropdown list, 3 values, Tools, Chemicals, Clothing), Date and Amount ($). I am trying to come up with a formula to sum amount of $ spent in a certain month in each Type of expense. So, for example, for much was spent in type Clothing between 06/01/18 and 06/30/18. Is there a way to do…
-
Enhancement Requests: Improved Row Reminders
Every once in a while, I run into a situation where I would like to send a Row Reminder, but Smartsheet's implementation does not help me. 99% of the Reminders on a sheet are generic and can automated, I'm not talking about those. I just talked to someone and they said "if you don't hear from me in 21 working days, contact…
-
Using a Form to enter multiple dates at once, rather than individually
We have developed a Smartsheet to track event support requests, and I have created a form for our clients to use for the reqeusts. Is it possible to use the calendar to enter multiple dates in one entry rather than having to refresh the form and enter a request for each individual date? Thanks! Javier
-
how to tie up % conclusion with actual date
Is there any way to generate a "temporal analysis of the evolution of % conclusion" on a project.? I would need a way which every time the update of a task occurred, the smartsheet fixed the actual date so at the end of that task I'll have the evolution timeline for that. Thanks,
-
Updates on a ticketing system
Hello All, we are setting up a ticketing system to manage a medium (but growing number) of instruments. Unfortenately not all service requests can be handled in one visit. How can the "actions taken" column be updated lets say from zero to several times. In the best case each update corresponds to a service visit date. Any…
-
Sort lines
Hi. Can somebody give some guidance on the sorting option for lines? The option turns to be disabled if I take the whole column, or I select several lines. The option only works with less than 10 lines or so... is it because of my free versión? Thanks
-
Smartsheet for Marketing
I am brand new to smartsheet, just trying it out to see if it would meet my needs. I run a marketing unit at a university, and currently use a system called Workfront for our project management and online proofing. Is there anyone out there using smartsheet for marketing? If so, what are the pros/cons you've come across…