-
VLOOKUP Function
It seems like others have inquired about VLOOKUP. I'm sure this is in the works as part of "enhancement request". Is there a timeline when this will be released?
-
Forms
Looking for some help in a Form that I'm creating. I am the Safety Director for a painting contractor and I'm trying to create a form that my crew forman will be filling out every morning. Why can't I have more than 1 field named the same? I'd like a check-box or drop-down field, for every employee, that specifies if they…
-
G-Suite reply in comments
I successfully have my emails in Gmail landing in the comments in a particular or new line in a sheet, works great and very helpful. I see in the added email in comments a "add reply" blank. Does this reply just stay with the comment or does it go back out to an email Maybe this is a wish list type of thing, but if a…
-
Calculate health of a smartsheet project.
I have created a smartsheet from a project management template. Start and Finish Dates, Durations, predecessor, % complete, are all working well. I can easily calculate the health of completed tasks by allowing a project manager to change the % complete and look at over all weighted averages of those complete tasks. That…
-
Feature Request
I have used Smartsheet for years and find it to be the best Project Management platform to date. I have a few features I'd like to suggest be added in the near future... please note if you'd find any of these helpful too. Hopefully this will help grab Smartsheet Developers/Engineers attention. - "View As (Other User)"…
-
Automated Call/Text Linked to Smartsheet
I'm wanting to link a Smartsheet/report to an automated calling/texting service like Call Multiplier or Dial My Calls. Similar to how a dentist or eye center may have an automated call when you're up for your appointment. In my case, I'm developing this to work with a project schedule to get a commitment from the…
-
sumif with children and checkboxes
I'm trying to create a setup where I sum together only the children if another box for that row is checked. I've come up with (see screenshot below as well): =SUMIF(CHILDREN(Include),1,CHILDREN()) But despite trying different variations of the formula I get everything back as #UNPARSEABLE I appreciate any help you can…
-
if-then-else logical function
I have a symbol column valued ( green, yellow,red). I want to set the color based on a logical formula as follows: There is Start and a Finish date columns. if ((Start <= Finish - 8, "Green"), IF(AND(Start > Finish - 8 , Start <= Finish), "Yellow"), IF(Start > Finish, "Red") Anyone, can you correct this? Thanks Art
-
Formula for Days overdue
I am using smartsheets to keep track of assigned items to my team. I want to insert a column that let's me know the days overdue. I don't know how to insert a forumla that does this. Can anyone help?
-
Problem with Gant Chart - Gear Icon not consistently shared
Hello All, The gear icon that I see in my gant chart schedule, is not showing up for certain people that I share the sheet with. This is a problem as our project managers need to be able to change the time line displays. Some people can see it, some people cant. I can not find the setting to always allow the gear icon to…
