-
Referring to comments/discussion in cell
Hi All I'm looking for a way how to insert text comments into cell. Is it possible (in read-only mode)? Use case: we have a sheet for issue tracking purposes which consist of the following columns: issue id, issue title, issue description, current state, status, etc. At present we use the “current state” column as a log by…
-
Sending auto update request based on % completion
Hi, I want to send update request automatically to shared users of that particular sheet after the % completion column is 100%. Please guide me, how it is possible. Thanks.
-
Enhancement Request: Sending completion email of a backup job to several people or groups
In the setup process of a backup one can direct Smartsheet to send an automated email when the job is done, so the backup can be downloaded and archived. The email addresse is fixed/pre-configured to the owner of the workspace. It would be great, if one could choose more than one person or even better a self configured…
-
Primary Column Not Shown In New Comments Digest
After the new update, the Primary Column isn't shown in the daily digest of comments. It just shows the Row Number. (We have the store name as the Primary Column, so all comments get listed, but only the row number designates which comments go with which stores.) (Example below) Smartsheet Team - Can we get the Primary…
-
Row & Update Requests - see message comment?
I have a sheet set up to track drafting requests. i.e. A staff member submits a request to create or update a site map. The persons in our drafting department get notified and one of them will start on the task. In trying to keep all communications within SS (and not email discussions), I've instructed the drafting…
-
Display a date on parent row only when all children rows contain date
How may we fix the below formula for parent row so that it displays the most-future-date from children row after all children rows are filled with dates? =IF(COUNTIF(CHILDREN(), 1) = COUNT(CHILDREN()), MAX(CHILDREN()), 0) Currently, "0" (nothing) is displayed on parent row no matter whether there is/are dates in children…
-
Using formula =MAX(children())
Dears: I'm talking about one Date formated column. When my Parent cell has that formula and I have 4 children's (2 filled and 2 unfilled) the formula returns the MAX value between the 2 filled cells. I want for my Parent the MAX from all four childrens. I need to return the MAX value only when the 4 childrens are filled.…
-
Need suggestion for duplicates
I have a sheet that allows deliveries to be entered. They have a date, location, start time and end time. I have restricted the times to whole hrs 5AM to 10PM. I would like to know if some enters a delivery at the same place on the same date with a time that overlaps another. Any suggestions on how this might be…
-
Critical- Need help with reports on iPhones
I have deployed a smartsheet with reports that allow our field staff to know when deliveries are comming. I have two reports, one is today's deliveries the other is the next 5 days. For some reason on some users iphones the two reports come up with "No Rows". Android have no issue, just some iphones. Need to get this…
-
Sheet Template; Not all Formulas Carry over
When using a template, why don't formulas copy over, even when I leave a dummy row in with the formulas, the new sheet doesnt carry the formiula on the next inserted row. I could have swore that previously, when you inserted a new row the formulas would pre populate.…
