-
Age
How do I create a formula to automatically calculate the age? I currently have this formula: =(Date of Birth-Current Date)/365.25
-
Update a line via form without rights to view the sheet
Hi, I have a list of adresses and would like to send an update request but without giving this person the rights to view the whole sheet. Any ideas how to make this? Thanks, Joachim
-
INDEX, MATCH, AND formula
I am trying to create an Index / Match cross-sheet formula if two cross-sheet criteria are met. Sheet One displays the Sales Reps for New and Modified Items: I want to display the Item Rep for NEW item types. The formula entered on Sheet Two is: =IF(AND(MATCH(Item1, {SHEET ONE_ITEM}, 0), MATCH("NEW", {SHEET ONE_ITEM…
-
Due Dates that exclude weekends and Holidays
I need a formula that will return a date that does not include weekends or holidays. For example: Notification Date 1/18/19 Due Date (formula that counts 20 business days from the notification date and excludes holidays). It should return 2/16/19 because MLK day is on Monday)
-
Glitches / Mixed up rows
There have been a handful of occasions now where we load Smartsheet and it looks nothing like it should. Rows get mixed up with no pattern to discern why. Luckily, I had someone take screen shots of what it looked liked before so we could straighten it out. But I need answers. Smartsheet is a great product, and so forth,…
-
Can information be pushed into a SmartSheet from an email message
Hi there, I am curious to find out if I can embed a button (or link) into an email that would make an entry into a SmartSheet. Let's say I want to send an email which asks the recipient to choose one of two options. I could send them to a SmartSheet form and have them fill it out, but what I would rather do is have them…
-
import and consolidate daily changed excel file with SS sheet
Hi, currently my team (4 members) uses one excel file to save information about insurance incidents (task tracking with regularly action documentation f.e. what have craftsmen done, has insurance paid a.s.o). It takes a few month until we all may use SmartSheet. Until that time I would like to daily or weekly import the…
-
Remove name from contact list
I've created a contact list in which I've entered a few names. When I open the 'Edit Column Properties', I see only the names I want in the 'Values' box. Yet when I try using the list to populate a cell, the list that opens includes my own name along with those I entered in the Values box. Because I can't see my name in…
-
Column based alert?
I have a workflow where I need to add a different site every couple days, as we confirm site visit. I want to send alert to the team ( about 40 people) to update and provide their availability to go to these sites. I only know of Alerts being row based in Smartsheet. Is there a way better way to approach this work flow?…
-
Conditional formatting not working for formulas with reference to another sheet
Hello I have an IF-formula in a cell which references values from another sheet. For examle IF(CELL_X from ANOTHER_SHEET = 10, "Ok", "Not OK"). I also have conditional formatting based on the values "Ok" and "Not Ok". However, the conditional formatting does not work reliable. Sometimes the cell is just unformatted. The…
