-
Smartsheet pricing and hardball tactics
Wondering if anyone else is experiencing this. For years we had a great experience with our sales reps and recently we were assigned new reps that said we had to have a 33 1/3% price increase. At this point, we need to look for alternatives to spreadsheet -- which is a shame -- but this kind of price increase is insane. I…
-
Unable to Save - Error message
Hi. I have used a smartsheet template, and edited to my credentials. However when I save i get an error message such as: Unable to reach smartsheet.com. Please check your internet connection. Our network connection is working perfectly fine. Is there something I am missing? Many thanks
-
Adding a photograph into a smartsheet form
I need to add a table of items into a smartsheet form but as there doesn't seem to be an option for a table. Would I be able to add it as a photograph for all users to be able to see when competing the form? - I cant seem to see an option for this either?
-
Formula % checked boxes in row
I have 5 check box columns in a sheet and would like to show the percentage checked for the individual rows in the 6th column. Column 6 should show 100% if all 5 columns in that row are checked, 80% if 4 columns in that row are checked, 60 % if 3 columns in that row are checked, etc. What is the best formula to use?
-
Displaying Date AND Time
Is there a way to display a date and time within a data field. I'm using Smartsheet to track the processing of incoming reports. Employees log when they assign the report to themselves and when they've completed it. I have the From and To dates, but would like to get this down to Hours since reports are mostly completed…
-
unable to sum numbers based on date criteria
Hi, currently i'm trying to sum up numbers against different dates. here i have different numbers for same date, hence would like to sum up those numbers against a specific date which is my criteria. i'm not getting the final sum instead formula showing zero. can anybody help me. here is the formula i used.…
-
email link duration
We frequently send links to documents to our clients - and they frequently don't click the link for more than 30 days. Is there a way to make a link last longer than that?
-
COUNTIF Formula, exclude "FALSE" values
I have a COUNTIF formula that is referencing multiple cells for a calculation depending on tier. If I use this version of the formula, the calculation will correctly exclude counting any cells with a "FALSE" value. If I have to skip a cell (i.e. can't use a colon reference to sum the data), then the formula counts the…
-
Networkdays when second date is empty
I'm trying to figure out how to get the network days when the second date column is blank. It should then just be 1. I'm going crazy trying to figure it out. Update: I am still playing with this formula. I've realized I just need an IFBlank formula. If blank, return 1. My formula returns #Incorrect argument set…
-
Automate timeline for a series of events in sequence?
Hi, I'm working on a project that have many subtasks (module 1, 2, 3 etc in the attached screenshot) and many sub-subtasks (subtask 1, 2, 3 etc). Because these sub-subtasks are sequential, I tried to figure out a way to automate the timeline, meaning any delay in subtask 1 (start2 in the screenshot) will cascade in all…