-
Auto-populating form fields
I'm working on a form right now and am having some issues that I'm hoping someone can help me with. I'm trying to develop a form that auto-populates specific fields. Something similar to the "request an update" feature, but in a form that I can edit the look and layout of. I've tried using a query string, but so far I…
-
Roundup causing error on reports
Hello, I added the new roundup formula to my sheet and this cause all of my reports that reference this column to show up as #unparseable only on the report. This shows as a value on the main sheet. To make this worse any other formula on this sheet shows up as #blocked until this is removed
-
REFRESH A SHEET
I linked two sheets (A and B) On sheet A are the name of customers from all country with other informations about them. Sheet B is the active sheet, I choose a country in a cell with a dropdown list. On other cells, I use VLOOK link to the dropdown list cells. Finally, by choosing a country name in the drowdown list I have…
-
Formula Confusion!
We are trialling smartsheet and overall enjoying it so far however we have run into a bit of brick wall and any help would be appreciated! We have a main sheet with all our orders on it, using an older version to muck about with layout at set up at this stage hence the old haulage dates! Each order has details of the sizes…
-
Cell Reference
Ok, I tend to think I am someone decent in Smartsheet, but I am STRUGGLING with something so simple and would love some help... Background - I have a project team and we use smartsheet forms for time tracking. Every month we archive the previous month's data on a separate sheet. However, to calculate metrics, I do a SUMIF…
-
Recording the date of a specific update and locking that date?
Greetings SMARTsheeters... Not sure if what I'd like to do is possible in SMARTsheet, but here goes... I'm working on a SMARTsheet that receives data adds and modifications from SMARTforms and autoupdate email requests. There will be various users entering and modifying the data in the SMARTsheet adhoc through these forms…
-
Checking Done for multiple cells
Hi! I am trying to find a formula to check a box Done when several other cells are checked done. Such as Master Task=done when Task 1, Task 2, Task 3 and Task 4 are checked done. My If Then formula doesn't seem to work. Any thoughts? =IF([Column2]1 = "Done", 1, 0)
-
populate a field based on if a due date is x days or less.
anybody by chance know what is the easiest way it possible to set up a formula that reads a field to auto populate a date that is say 10 days before another date (due date)
-
Allow a cell to only be certain days of the month
I put together schedules that include public hearing dates that are typically certain days of the month , i.e. 2nd Tuesday, is there a way to assign this to a cell in my schedule? Currently I have to go to that point in my schedule and manually find the date and each time the schedule changes I have to make sure I update…
-
Hyperlink from Sheet clickable in Metric Widget on Dashboard
We are having people create a hyperlink in a cell on a sheet to a word document saved on our O365 sharepoint. I want this link to then be available on the dashboard. I currently have the cell linked in the Metric Wizard, but when viewing the dashboard, the link is broken and only the words are there. The users are not able…